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

138 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
mondes9432235(None) 
modes85537411mo_des
monades103713821monades
monde85723141monde_
mondos95217331mondos
monies83233161monies
montes84226931montes
sondes74922871sondes
anodes74418762anodes
blondes104213162blondes
bodes84935102bo_des
bonded104719952bonded
bonder95324782bonder
bonders104120662bonders
bonds86126842bond_s
bones76446532bon_es
bonnes85621452bonnes
bonzes175116102bonzes
codes86247292co_des
condoes104319202condoes
condos94322332condos
cones76457422con_es
conges94928172conges
conies84338592conies
contes84432912contes
donees74519492donees
fonded115717042fonded
fonder104120062fonder
fondest11312402fondest
fondles113512612fondles
fonds95824822fond_s
fondues11399312fondues
fondus105210942fondus
hondas10313352hondas
hondles113614522hondles
hones88144492hon_es
hordes104921632hordes
jones125028182jon_es
lodes66436912lo_des
longes75925572longes
manes76648962man_es
manges94628942manges
manses84225512manses
mantes84430782mantes
mended104418682mended
mender93520792mender
menders103818802menders
mends84927692mend_s
menses84222452menses
merdes94518602merdes
minces104420802minces
minded103817832minded
minder94822502minder
minders103720122minders
minds85427122mind_s
mines75651952min_es
minkes124618782minkes
minxes154612982minxes
mode75840302mo_de_
model84521692mo_del
models94216352mo_dels
modem103717142mo_dem
modems114610762mo_dems
modest93818452mo_dest
mods77945052mo_d_s
modus85417202mo_dus
moires8915632moires
mojoes15399522mojoes
mokes114631032mo_kes
molded104414082molded
molder93819272molder
molders103315552molders
molds85324832mold_s
moles74747922mo_les
molies84429512molies
momes95134472mo_mes
monads94515302monads
monas74732152mon_as
mondo85721232mond_o
money104826842mon_ey
moneys115513622moneys
monger94418332monger
mongers104217272mongers
mongoes103415712mongoes
mongos94318622mongos
monie75631652monie_
monied94319462monied
monkey153710592monkey
monkeys16407422monkeys
monks116123392mon_ks
monodies11312502monodies
monos75930862mon_os
mons68152262mon__s
monte75829772monte_
months113812932months
moods85224622mood_s
mopeds11499662mopeds
mopes95134982mo_pes
mores76249642mo_res
moshes115222872moshes
mosses85527682mosses
motes75944002mo_tes
mottes85523692mottes
moues75732842mo_ues
mounded113711982mounded
mounds93915132mound_s
mouses85531422mouses
moves106128422mo_ves
movies115118452movies
moxies154317402moxies
nodes64633492no_des
nonces84418832nonces
nones55639132non_es
odes57243242_o_des
ones46146532_on_es
ponces104720842ponces
ponded105218772ponded
ponder94521692ponder
ponders103618842ponders
ponds85323402pond_s
pones74547042pon_es
ponies84833462ponies
pontes83627852pontes
rodes614039082ro_des
rondel73212642rondel
rondels82510052rondels
rondos74616732rondos
sonde64622832sonde_
sonder73623522sonder
sonders83820712sonders
sones55444142son_es
tondos75115922tondos
tones56048662ton_es
tonnes65320852tonnes
wonder103617812wonder
wonders113315992wonders
yonder103214132yonder
zones145528042zon_es

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.346516448.0
2DLD Change Limit825511382.26336478.6
3Display Results1381380.0334181.8
 (SQL Overall)1786911382.64267634.7
 
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.