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 “loaves” with Change Limit: [1] [2]

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

120 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
loaves9481385(None) 
laves86039151l_aves
leaves94222381leaves
loves85332011lo_ves
oaves84925611_oaves
soaves94218671soaves
agaves104611512agaves
aves76142602__aves
braves115524082braves
caves105639702_caves
claves115020062claves
cleaves124111622cleaves
cloves114918822clo_ves
coaxes154715632coaxes
corves115122522corves
coves105539172co_ves
craves115825392craves
deaves105319532deaves
doves94728152do_ves
eaves85231992_eaves
faves115331422_faves
gloves104115182glo_ves
graves104624002graves
haves116034872_haves
heaves124120302heaves
hoaxes163611692hoaxes
hooves124815482hooves
knaves13439522knaves
laces76141762l_aces
lades65141272l_ades
lakes95737652l_akes
lames75445542l_ames
lanes54946792l_anes
lares54852632l_ares
lases54944762l_ases
lavas85422222l_avas
lave75642142l_ave_
laved95028592l_aved
laver85031792l_aver
lavers94526362l_avers
lavs76734152l_av_s
laxes125430092l_axes
lazes145129572l_azes
leases65428112leases
leave84723722leave_
leaved105719022leaved
leaven95013072leaven
leavens10409302leavens
leaver94321512leaver
leavers103717782leavers
lianes63819322lianes
lives86133192l_ives
loaches123613982loaches
loaded84616872loaded
loader74316312loader
loaders83413432loaders
loads65323372loa_ds
loafed104011152loafed
loafer93610942loafer
loafers10349462loafers
loafs85616992loa_fs
loamed94414612loamed
loams75619862loa_ms
loaned73816292loaned
loaner64416502loaner
loaners73913622loaners
loans56026462loa_ns
loathes103513242loathes
lobes75331002lo_bes
locales93715092locales
locates93218812locates
locoes85516582locoes
lodes66436912lo_des
lodges86820152lodges
loges66534202lo_ges
longes75925572longes
looies65025832looies
looses67328242looses
lopes76437342lo_pes
lores55045402lo_res
lories64933042lories
loses56742012lo_ses
losses65925232losses
lottes65322752lottes
louies64525102louies
loupes84918052loupes
louses66230282louses
louver94110392louver
louvers10359102louvers
louvres10356522louvres
lovages1138032lovages
lovats939072lovats
love75234762lo_ve_
loved95021362lo_ved
lover85526452lo_ver
lovers94223432lo_vers
lowes85732462lo_wes
loxes125227472lo_xes
lyases95211872lyases
moves106128422mo_ves
naves87030382_naves
oases55330982_oases
olives94313952olives
paves104833922_paves
pooves113914712pooves
raves85441972_raves
reaves94127572reaves
roves84834482ro_ves
saves85838632_saves
shaves125224932shaves
slaves95023022slaves
sleaves103813202sleaves
soave84219052soave_
solves95018222solves
staves94525192staves
traves94222742traves
waves115633922_waves
weaves123616372weaves
wolves124510852wolves
zouaves1933892zouaves

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit825511202.40634310.5
3Display Results1201200.0304000.0
 (SQL Overall)1786911202.77964300.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.