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 “fiance” 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.

465 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
fiance1131074(None) 
fiancee1238951fiancee
fiances12310671fiances
finance1238581finance
affiance1645652affiance
chance134617092chance
dance85223132_dance
defiance1477632defiance
face96140122f_a_ce
faience1237522faience
fancy134615482f_ancy
fane75343572f_an_e
farce104925322f_arce
fence105319912f_ence
fiacre1137622fiacre
fiancees1335102fiancees
fiasco11104922fiasco
fice95737112fi__ce
fierce11348912fierce
finale94116762finale
financed1435122financed
finances1338662finances
finca104714502fi_nca
finch135416972fi_nch
fine75147952fi_n_e
flange103411972flange
franc104615412franc_
francs114112192francs
glance94312312glance
hance105424152_hance
lance75126722_lance
liane54720662lian_e
mince95325232mi_nce
nance74721842_nance
nuance859042nuance
prance104318572prance
rance75028512_rance
seance83716692seance
since75024172si_nce
stance84316912stance
trance84718762trance
usance858012usance
wince105220882wi_nce
yince105214252yi_nce
abidance1346323abidance
ace59656833__a_ce
acne66625873__acne
advance1346043advance
affianced1843033affianced
affiances1745153affiances
alane56135613alan_e
alliance1097273alliance
ambiance1446073ambiance
ananke1038283ananke
ane37866953__an_e
ante46538903__ante
apace94718383apa_ce
askance1345923askance
balance11510263balance
banco94019393_banco
bane65250433_ban_e
beanie83618593beanie
bice86235563bi__ce
biface1358103biface
binate8419773binate
bine66650863bi_n_e
binge85125513bi_nge
blanch133410853blanch
bounce104014833bounce
brace95629273bra_ce
branch134014783branch
brisance1245953brisance
cancel105316683_cancel
cancer104220923_cancer
cane66653123_can_e
canoe75627253_canoe
chanced154113213chanced
chancel144011783chancel
chancer144215633chancer
chances145218093chances
chancre14348783chancre
chancy164010863chancy
change124116753change
cilice103213353cilice
cinch124516243ci_nch
cine66242943ci_n_e
cofinance1645553cofinance
cranch133613533cranch
crane75331603cran_e
dace76934923_da_ce
danced105315253_danced
dancer94817613_dancer
dances95120653_dances
defiances1557033defiances
deviance1477083deviance
dice75841893di__ce
diene65720133dien_e
dine55555333di_n_e
dinge75627303di_nge
distance11311853distance
dunce86319263_dunce
durance1059113durance
efface14366673effa_ce
enhance1239693enhance
evince1137763evince
fable105824753f_able
faced117727653f_a_ced
facer105525053f_a_cer
faces106439433f_a_ces
facet106038523f_a_cet
fact97142543f_a_ct
fade85736343f_a_de
fadge104817003f_adge
faeces114713123f_aeces
faiences1337053faiences
faille93414743faille
fain75840563fain__
faineance1443373faineance
fainer94717243fainer
faint85837063fain_t
fainted114211723fainted
fainter103611053fainter
faints94818783faints
fake115534943f_a_ke
falces115216003f_alces
false84818123f_alse
fame95639393f_a_me
fan67158863f_an__
fancied133310603f_ancied
fancier123412063f_ancier
fancies124018783f_ancies
fanes84639893f_anes
fang85432563f_an_g
fanga96119633f_anga
fanged114318233f_anged
fangs96224083f_angs
fanjet16311393f_anjet
fanned104117473f_anned
fanner94218183f_anner
fanny114816043f_anny
fano75831693f_an_o
fanon84619013f_anon
fanos85926503f_anos
fans76247373f_an_s
fanum10313443f_anum
farced125216533f_arced
farcer115016083f_arcer
farces115223323f_arces
farci105919313f_arci
farcie114816473f_arcie
farcy135217093f_arcy
fare76354463f_a_re
farle86929243f_arle
fasces114914543f_asces
fate75444283f_a_te
fauces114916153f_auces
faucet115816553f_aucet
faunae95210373faunae
fauve114712073f_auve
fave105532963f_a_ve
faze165630043f_a_ze
feasance1345823feasance
fease84824873fea_se
feaze175216313fea_ze
fenced124412713f_enced
fencer114613533f_encer
fences114617113f_ences
fennec11326913fennec
fiacres1237253fiacres
fiar76427333fia__r
fiars86720833fia_rs
fiaschi1542793fiaschi
fiascoes13134923fiascoes
fiascos12124743fiascos
fiat76646643fia__t
fiats85324483fia_ts
fibranne1343373fibranne
fibre104812843fi_bre
fices106031163fi__ces
fiche134616743fi_che
fickle153912973fickle
fico95824593fi__co
fiddle113613383fiddle
fidge104516063fi_dge
fie67152443fi___e
fiend95312983fien_d
fiends104110293fiends
fiercer12356953fiercer
fife106027703fi__fe
figure10258833figure
filaree10611223filaree
filch134813323fi_lch
file75446643fi__le
fille84327403fi_lle
filose96112503filose
fimble133611753fimble
fin66458033fi_n__
finable122213623finable
finagle11238313finagle
final83922033fi_nal
finales104016013finales
finals94316163finals
financier1443713financier
fincas113512073fi_ncas
finches153914193fi_nches
find87532603fi_n_d
finder104020233fi_nder
finds95424823fi_nds
fined94930503fi_ned
finer85431563fi_ner
fines86644263fi_nes
finger104920333fi_nger
finis86824263fi_nis
finite9316823finite
fink117532123fi_n_k
finked144214623fi_nked
finks125424223fi_nks
finned104114603finned
finnier10319953finnier
finny114716753fi_nny
fino76034693fi_n_o
finos86226953fi_nos
fins75849093fi_n_s
fipple13329063fipple
fique1739143fi_que
fire76245593fi__re
firn76927503firn__
firns86018543firn_s
fisc96819753fi_sc_
fiscs105311883fi_scs
fitch134816873fi_tch
five107629743fi__ve
fixable19218193fixable
fixate1638733fixate
fixure16256543fixure
fizzle17369713fizzle
flack144519413fla_ck
flake125119973fla_ke
flambe13489153flambe
flame105124443fla_me
flan76134183flan__
flanes94522423flanes
flanged123810843flanged
flanger113412623flanger
flanges113413273flanges
flank124618093flan_k
flanked153710643flanked
flanken14226763flanken
flanker143911293flanker
flanks133913403flanks
flannel1035423flannel
flans85327973flan_s
flare84823633fla_re
fleece11369903fleece
flench144010813flench
flense938903flense
flinch144010103flinch
flounce1235413flounce
force105324273f_orce
frae75330473fra__e
fraise94214913fraise
frame105821803fra_me
francize2246853francize
frank124417513fran_k
franked153610053franked
franker143510183franker
franks134912733franks
frappe13286953frappe
french143511213french
friable122612563friable
fringe104013953fringe
frounce1236153frounce
furane94015493furan_e
furnace1235943furnace
fyce126316833f__yce
gane55145303_gan_e
giant65430593gian_t
giants74713503giants
glace87420163gla_ce
glanced11439233glanced
glancer103710073glancer
glances104113143glances
grace85124543gra_ce
grange83716203grange
guidance1244983guidance
hances115621283_hances
hanse85722793_hanse
hence104920053_hence
hinge95323453hi_nge
ice56737243_i__ce
inane52820343_inane
inch95420823_i_nch
jane115031483_jan_e
jaunce15367433jaunce
jinnee13411573jinnee
jounce153310733jounce
joyance1944773joyance
kane85133973_kan_e
kiang104811353kian_g
kiangs11378363kiangs
kinase104210653kinase
kine85643433ki_n_e
lace66848473_la_ce
laitance1045983laitance
lanced93717723_lanced
lancer84319973_lancer
lances84824103_lances
lancet84223573_lancet
lane45153333_lan_e
launce8469183launce
liable81415813liable
liaise6310693liaise
liana53915893lian_a
lianas63713383lianas
lianes63819323lianes
liang64914413lian_g
liangs74410593liangs
lice66045063li__ce
licence11119373licence
linac7315413linac_
linacs8310813linacs
linage7713403linage
line46965573li_n_e
mace87345793_ma_ce
manche133515103_manche
mane65052033_man_e
mange84930203_mange
manse75528233_manse
meanie83718393meanie
menace103216943menace
mice87442233mi__ce
minae75627723mi_nae
minced114114913mi_nced
mincer104017363mi_ncer
minces104420803mi_nces
mincy125817413mi_ncy
mine67256173mi_n_e
minke115421763mi_nke
nances83618643_nances
nancy105214923_nancy
nice65534713ni__ce
niece74814503ni_ece
nine45842173ni_n_e
nonce75719823_nonce
nuanced1036203nuanced
nuances938523nuances
nuisance1045713nuisance
offence1545353offence
once65423083__once
orange74016323orange
ounce77019933_ounce
pace86345773_pa_ce
painch133511323painch
pane64950293_pan_e
panne76623653_panne
peace95026083pea_ce
penance11313443penance
pence94924453_pence
piaffe1494913piaffe
pian66136093pian__
pianic103714123pianic
piano76118713pian_o
pianos84315933pianos
pians75126963pian_s
piazze1634683piazze
picante11310523picante
pice84641093pi__ce
piece96717993pi_ece
pierce104010393pierce
pincer104019173pi_ncer
pinch125619303pi_nch
pine67755713pi_n_e
pinnace113510313pinnace
pinnae84414643pinnae
piquance2144213piquance
pittance1246113pittance
place94824613pla_ce
plaice10311553plaice
planch133711443planch
planche14299753planche
plane74929143plan_e
pliancy1435593pliancy
ponce95222513_ponce
pounce105214093pounce
pranced123714043pranced
prancer113613383prancer
prances113618773prances
prince104114763prince
quince173910133quince
race66746263_ra_ce
radiance1148123radiance
rances84625443_rances
ranch105019793_ranch
ranee55438103_ranee
range64728423_range
refinance14117653refinance
reliance10310483reliance
riant55833153rian_t
rice64942913ri__ce
riddance1243973riddance
rinse54820973ri_nse
romance11311083romance
saice75424053_saice
sane45954343_san_e
sauce75121653_sauce
scarce104013633scarce
science1138793science
sconce104711723sconce
seances93015343seances
sice65545593si__ce
signee73617233signee
silane62718053silan_e
silence9310223silence
sine46560623si_n_e
singe65731133si_nge
sonance9310313sonance
space95325673spa_ce
spancel1147363spancel
spence103813793spence
stances93715963stances
stanch113812373stanch
stane55933003stan_e
tace65342513_ta_ce
tenace82715693tenace
thane86122533than_e
thence112010853thence
tierce8339843tierce
tinct76126233ti_nct
tine45855133ti_n_e
tinge64626633ti_nge
tisane6311573tisan_e
trace75829613tra_ce
tranced104414173tranced
trances93919643trances
tranche123312223tranche
usances967373usances
usaunce9103383usaunce
valance1269253valance
valiance1397393valiance
vane75534693_van_e
variance1397413variance
viable111613773viable
viand9511073vian_d
viands1047813viands
vibrance1545863vibrance
vice95732853vi__ce
vinca105315163vi_nca
vine75643683vi_n_e
vivace1436553vivace
voidance1444723voidance
wane76344723_wan_e
whence14187933whence
wienie9229973wienie
winced124415343wi_nced
wincer115018193wi_ncer
winces114819113wi_nces
wincey144110383wi_ncey
winch135016663wi_nch
wine74953423wi_n_e
winze175014853wi_nze
zinc156819093zi_nc_
zinced18419413zi_nced
zincs165312933zi_ncs
zincy195413513zi_ncy
zine137036153zi_n_e

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127164654.98622606.5
3Display Results4654650.1403321.4
 (SQL Overall)1786914655.51632395.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.