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

189 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
zouaves193389(None) 
zouave1833571zouave_
loaves94813852lo_aves
oaves84925612_o_aves
soaves94218672so_aves
agaves104611513_agaves
aves76142603___aves
behaves15198523behaves
bolases93315003bolases
boraces113716853boraces
borages103917163borages
boranes93720403boranes
borates94823013borates
boraxes163511633boraxes
boucles113113003boucles
bouffes15388633bouffes
bougies103715183bougies
boules84925973bou_les
boulles93114123boulles
bounces113813683bounces
bournes93615023bournes
bourses94014303bourses
bouses84931783bou_ses
braves115524083_braves
caves105639703__caves
claves115020063_claves
cleaves124111623cleaves
coaxes154715633co_axes
comakes154413643comakes
comates114123643comates
concaves1538913concaves
corves115122523co_rves
couches144020473couches
coulees9315513coulees
coupes105022523cou_pes
couples115317053couples
courages11311393courages
courses94218893courses
couvades1435613couvades
coves105539173co__ves
cowages13310943cowages
craves115825393_craves
curves114619283_curves
deaves105319533_deaves
donates83217223donates
dosages92310803dosages
dotages92311793dotages
doubles103113353doubles
douches134315233douches
douses74928933dou_ses
doves94728153do__ves
eaves85231993__eaves
eluates72014683eluates
equates162012323equates
fauves125610423fau_ves
faves115331423__faves
folates103218453folates
forages114217283forages
gouaches1436203gouaches
gouges86318693gou_ges
gourdes9109383gourdes
graves104624003_graves
greaves113311443greaves
guavas1037163_guavas
haves116034873__haves
heaves124120303_heaves
hoaxes163611693ho_axes
homages131011583homages
hooves124815483ho_oves
houses96032273hou_ses
iodates8312903iodates
jouals1338923joua_ls
joules134116823jou_les
jounces16369853jounces
knaves13439523_knaves
laves86039153__laves
leaves94222383_leaves
locales93715093locales
locates93218813locates
louies64525103lou_ies
lounges84811353lounges
loupes84918053lou_pes
louses66230283lou_ses
louver94110393lou_ver
louvers10359103lou_vers
louvres10356523louvres
lovages1138033lovages
loves85332013lo__ves
mauves113811553mau_ves
monades103713823monades
morales93619403morales
motives123611893motives
mouches143815963mouches
moues75732843mou__es
moulages1138053moulages
mouses85531423mou_ses
mousses94012703mousses
moves106128423mo__ves
naves87030383__naves
nonages8313843nonages
nopales93812523nopales
notates72817483notates
nouses64627163nou_ses
noyades1136563noyades
oases55330983_o_ases
octaves12316963octaves
ogives10367913_ogives
olives94313953_olives
orates64328613_orates
ouches114322183_ouches
ounces83617773_ounces
ouphes113614633_ouphes
outages82317323_outages
outraves112313833_outraves
outvies102214243_outvies
ozonates1745963ozonates
paves104833923__paves
pomaces132712123pomaces
pomades123711733pomades
pooves113914713po_oves
potages102416423potages
pouches144116743pouches
pouffes15408123pouffes
pounces114113893pounces
quakes194013343_quakes
quaver18309313_quaver
quavers19309013_quavers
raves85441973__raves
reaves94127573_reaves
repaves123513653repaves
rotates72819773rotates
roubles93413513roubles
rouches124217893rouches
roues56039353rou__es
rouges76022383rou_ges
roulades957173roulades
rouses65436283rou_ses
routes66129313rou_tes
roves84834483ro__ves
saves85838633__saves
shaves125224933_shaves
sheaves134412973sheaves
slaves95023023_slaves
sleaves103813203sleaves
soave84219053so_ave_
socages101012053socages
solaces93116133solaces
solates73523853solates
solves95018223so_lves
souaris7312333souaris
sources9312173sources
souses64229243sou_ses
soutanes8312933soutanes
squares163714463squares
staves94525193_staves
suave83519873_suave_
suaver93014233_suaver
suavest10310623_suavest
thraves13469713thraves
tolanes74216313tolanes
toluates8138903toluates
topazes1857313topazes
touches125118343touches
toupees938513toupees
touses64229673tou_ses
tousles74113933tousles
touzles16359223touzles
towages1139233towages
traves94222743_traves
turves94212693_turves
votives13337953votives
vouches153914113vouches
voyages1435703voyages
waves115633923__waves
weaves123616373_weaves
wolves124510853wo_lves
zaxes215113823z__axes
zocalos1835393zocalos
zoeae144412483zoea_e_
zoeas145815613zoea__s
zombies2037993zombies
zonae145116443zona_e_
zonate154114923zonate_
zonated173310533zonated
zones145528043zo__nes
zonules1647793zonules
zouks184410503zou__ks
zounds164310173zou_nds
zymases21938333zymases

Search took 9 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.440406115.9
2DLD Change Limit1340271897.61017612.0
3Display Results1891890.0762486.8
 (SQL Overall)1786911898.12621990.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.