Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “fiancee” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

166 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
fiancee123895(None) 
fiance11310741fianc_e
fiancees1335101fiancees
fiances12310671fiances
fiacre1137622fia_cre
finance1238582financ_e
financed1435122financed
finances1338662finances
affiance1645653affianc_e
affianced1843033affianced
affiances1745153affiances
cancel105316683_cancel
cancer104220923_cancer
chance134617093chanc_e
chanced154113213chanced
chancel144011783chancel
chancer144215633chancer
chances145218093chances
chancre14348783chancre
dance85223133_danc_e
danced105315253_danced
dancer94817613_dancer
dances95120653_dances
defiance1477633defianc_e
defiances1557033defiances
face96140123f_a_c_e
faced117727653f_a_ced
facer105525053f_a_cer
faces106439433f_a_ces
facet106038523f_a_cet
facete115014833f_a_cete
faeces114713123f_aeces
faience1237523faienc_e
faiences1337053faiences
fainer94717243fain_er
fainted114211723fainted
fainter103611053fainter
falces115216003f_alces
fancied133310603f_ancied
fancier123412063f_ancier
fancies124018783f_ancies
fancy134615483f_anc_y
fane75343573f_an__e
fanes84639893f_an_es
fanged114318233f_anged
fanjet16311393f_anjet
fanned104117473f_anned
fanner94218183f_anner
farce104925323f_arc_e
farced125216533f_arced
farcer115016083f_arcer
farces115223323f_arces
farcie114816473f_arcie
fasces114914543f_asces
fauces114916153f_auces
faucet115816553f_aucet
fence105319913f_enc_e
fenced124412713f_enced
fencer114613533f_encer
fences114617113f_ences
fiacres1237253fiacres
fiaschi1542793fiaschi
fiasco11104923fiasc_o
fiascoes13134923fiascoes
fiascos12124743fiascos
fice95737123fi__c_e
fices106031163fi__ces
fiche134616743fi__che
fierce11348913fierc_e
fiercer12356953fiercer
filagree1295183filagree
filaree10611223filaree
finable122213623finable
finagle11238313finagle
finale94116763fi_nale
finales104016013finales
financier1443713financier
finca104714503fi_nc_a
fincas113512073fi_ncas
finch135416973fi_nc_h
finches153914193fi_nches
finder104020233fi_nder
fine75147963fi_n__e
fined94930503fi_n_ed
finer85431563fi_n_er
fines86644263fi_n_es
finger104920333fi_nger
finite9316823fi_nite
finked144214623fi_nked
finned104114603fi_nned
finnier10319953finnier
fitchee152710783fitchee
flambee144210013flambee
flanes94522423flan_es
flange103411973flan_ge
flanged123810843flanged
flanger113412623flanger
flanges113413273flanges
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flannel1035423flannel
franc104615413franc__
francize2246853francize
francs114112193franc_s
franked153610053franked
franker143510183franker
glance94312313glanc_e
glanced11439233glanced
glancer103710073glancer
glances104113143glances
grandee93115513grandee
grantee83217133grantee
hance105424153_hanc_e
hances115621283_hances
jinnee13411573ji_nnee
lance75126723_lanc_e
lanced93717723_lanced
lancer84319973_lancer
lances84824103_lances
lancet84223573_lancet
liane54720663lian__e
lianes63819323lian_es
licencee12116473licencee
manche133515103_manche
mince95325233mi_nc_e
minced114114913mi_nced
mincer104017363mi_ncer
minces104420803mi_nces
nance74721843_nanc_e
nances83618643_nances
nuance859043nuanc_e
nuanced1036203nuanced
nuances938523nuances
pincer104019173pi_ncer
planche14299763planche
prance104318573pranc_e
pranced123714043pranced
prancer113613383prancer
prances113618783prances
rance75028513_ranc_e
rances84625443_rances
ranee55438103_ran_ee
seance83716693seanc_e
seances93015343seances
signee73617233sign_ee
since75024173si_nc_e
sincere9310553si_ncere
spancel1147363spancel
stance84316913stanc_e
stances93715963stances
standee83514513standee
trance84718763tranc_e
tranced104414173tranced
trances93919643trances
tranche123312223tranche
usance858013usanc_e
usances967373usances
whangee14268623whangee
wince105220883wi_nc_e
winced124415343wi_nced
wincer115018193wi_ncer
winces114819113wi_nces
wincey144110383wi_ncey
yince105214253yi_nc_e
zinced18419413zi_nced

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.403443402.0
2DLD Change Limit1340271666.01622278.4
3Display Results1661660.0632634.9
 (SQL Overall)1786911666.48227567.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.