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

204 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
zouave183357(None) 
zouaves1933891zouaves
soave84219052so_ave
suave83519872_suave
zoeae144412482zoea_e
zonae145116442zona_e
zonate154114922zonate
acuate8315633acuate
agave95314033_agave
aquae142212713aqua_e
ave67748703___ave
behave14209013behave
borage93917013borage
borane84620213borane
borate85026153borate
boucle103712783boucle
bouffe14438313bouffe
bougie93613273bougie
boule74828043bou_le
boulle84614613boulle
bounce104014833bounce
bourne83714093bourne
bourse84414333bourse
bouse75931853bou_se
brave104925503_brave
cave95941263__cave
clave105420153_clave
cleave114212513cleave
comade114415323comade
comae97128423coma_e
comake144413423comake
comate104124843comate
concave1439373concave
coude85022633cou_de
coulee8323503coulee
coupe96023483cou_pe
couple104415963couple
courage10310993courage
course85117783course
couvade1335063couvade
cove95837073co__ve
cowage12310663cowage
coxae146115183coxa_e
crave105626313_crave
curve104920023_curve
deave95022333_deave
donate73619503donate
dosage82810003dosage
dotage82711613dotage
double94013993double
douce85518423dou_ce
douche124613223douche
douse66329723dou_se
dove85131563do__ve
drave95219273_drave
eave75733583__eave
eluate62315433eluate
equate152012463equate
fauve114712073fau_ve
fave105532963__fave
folate93320393folate
forage104617003forage
forgave1435853forgave
gave84634053__gave
gouache1335033gouache
gouge78220063gou_ge
gourde8107933gourde
grave94624873_grave
greave104611493greave
guava938583_guava
have106137073__have
heave114521813_heave
homage121210603homage
house89131423hou_se
hove107132223ho__ve
iodate7313503iodate
joual12311653joua_l
jouals1338923jouals
joule124918203jou_le
jounce153310733jounce
knave12389463_knave
lave75642143__lave
leave84723723_leave
loaves94813853lo_aves
lobate82915243lobate
locale83915653locale
locate83919843locate
louche115212663louche
louie55023513lou_ie
lounge75211213lounge
loupe75319513lou_pe
louse56131013lou_se
louver94110393lou_ver
louvre9425683louvre
lovage1037353lovage
love75234763lo__ve
mauve104013273mau_ve
morae75831193mora_e
morale85220553morale
motive113112143motive
moue65835573mou__e
moulage1037903moulage
mouse77133003mou_se
mousse84813033mousse
move96630723mo__ve
nave75732313__nave
nonage7313683nonage
notate63217863notate
novae85913123nova_e
noyade1036423noyade
oaves84925613_o_aves
octave11157343octave
ogive9379093_ogive
olive84817153_olive
orate55133303_orate
ounce77019933_ounce
ouphe104413263_ouphe
ourie54027303_ourie
outage72017533_outage
outate62923403_outate
outgave11259563_outgave
outrave102614413_outrave
outre53922203_outre
outvie92412803_outvie
ovate84214393_ovate
ozonate1646863ozonate
pave96133893__pave
pomace123111913pomace
pomade113611333pomade
poove104514303po_ove
potage92715903potage
pouffe14448263pouffe
pounce105214093pounce
quake184114643_quake
quale143617853_quale
quare143920543_quare
quate144521413_quate
quaver18309313_quaver
rave75542093__rave
reave84528023_reave
regave104713383regave
repave114813873repave
rotate63320343rotate
rouble83913313rouble
rouche114714313rouche
roue45941743rou__e
rouge65423443rou_ge
roulade857003roulade
rouse56634703rou_se
route55132073rou_te
rove75136983ro__ve
save75741363__save
shave114425893_shave
sheave124514003sheave
slave84224033_slave
sleave94714153sleave
soaves94218673so_aves
socage91012123socage
solace83415823solace
solate64526073solate
solve85618943so_lve
souari6311383souari
source8410673source
souse56530773sou_se
soutane7312063soutane
square154513363square
stave85324993_stave
suaver93014233_suaver
thrave126010273thrave
togae67020113toga_e
togate74515683togate
tolane64316583tolane
toluate7159343toluate
touche114916173touche
toupee8316133toupee
touse55430673tou_se
tousle64514653tousle
touzle15429003touzle
towage1039833towage
trave85223033_trave
votive12348933votive
voyage1335473voyage
wave105234733__wave
weave115218533_weave
wove105624313wo__ve
youse85322233you_se
zoa128529993zo_a__
zocalo1735803zocalo
zoea137118423zoea__
zoeal144813783zoea_l
zoeas145815613zoea_s
zombie1937323zombie
zona136321963zona__
zonal145116853zona_l
zonary1838793zonary
zonated173310533zonated
zone135231083zo__ne
zonulae1645963zonulae
zonule1577483zonule
zouk174413543zou__k
zouks184410503zou_ks
zounds164310173zounds
zowie174313843zo_wie
zymase201997483zymase

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.1401276364.3
2DLD Change Limit1127162045.47020606.2
3Display Results2042040.0633238.1
 (SQL Overall)1786912045.67331498.5
 
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.