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

155 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
mottes8552369(None) 
lottes65322751lottes
mattes85624531mattes
montes84226931montes
motes75944001mo_tes
motets84216191motets
motte75526971motte_
mottles93415801mottles
mottoes93412191mottoes
mottos84615241mottos
motts76527001mott_s
rottes64524831rottes
boites84322702boites
bottles94216272bottles
botts75224862bott_s
buttes84822562buttes
comtes106222812comtes
contes84432912contes
cotes76347842co_tes
cottas84615572cottas
cotter84926672cotter
cotters94323452cotters
dotes65836692do_tes
dotted84717522dotted
dottel73610892dottel
dottels8327782dottels
dotter74419342dotter
dotters83715972dotters
dottles83912282dottles
emotes84620282emo_tes
fortes95327182fortes
fyttes1236932fyttes
gotten73410112gotten
hotted104319942hotted
hotter94720082hotter
hottest10411382hottest
hotties103016962hotties
jotted143615172jotted
jotter134315632jotter
jotters143413802jotters
lattes65324202lattes
lotte54923852lotte_
lotted74222402lotted
lotter64025602lotter
lotters73921062lotters
lottos64613102lottos
mantes84430782mantes
mates75251362m_ates
matres84522232matres
matte75626842matte_
matted94521412matted
matter84325342matter
matters94421752matters
matts76829182matt_s
metates92720012metates
metes74736212m_etes
metres85121562metres
mettles94115022mettles
mites75141802m_ites
mitres83922072mitres
mitten83914092mitten
mittens9349882mittens
mitts75523752mitt_s
moated94819002moated
moats75827642moat_s
modes85537412mo_des
mofettes1386082mofettes
moires8915632moires
mojoes15399522mojoes
mokes114631032mo_kes
moles74747922mo_les
molies84429512molies
molted94217472molted
molten83311812molten
molter84119422molter
molters93816972molters
molts76032092molt_s
momes95134472mo_mes
mondes94322352mondes
monies83233162monies
monte75829772monte_
months113812932months
mooted94120372mooted
mooter83921092mooter
mooters93818622mooters
moots75831662moot_s
mopes95134982mo_pes
mores76249642mo_res
morts75533562mort_s
moshes115222872moshes
mosses85527682mosses
moste75925082moste_
mostest9314792mostest
mosts76028542most_s
mote67048082mo_te_
motel76623242mo_tel
motels83616902motels
motet75641192mo_tet
motey105922952mo_tey
mother113718642mother
mothers123717622mothers
moths106021552mo_ths
motifs1139672motifs
motiles93317432motiles
motives123611892motives
motley1139382motley
motleys1235682motleys
motors84616602motors
mots66853162mo_t_s
mott66648442mott__
mottle84116052mottle
mottled10409972mottled
mottler94410342mottler
mottlers10388182mottlers
motto76119512mott_o
moues75732842mo_ues
mouses85531422mouses
mouths115214532mouths
moves106128422mo_ves
movies115118452movies
moxies154317402moxies
mutates92215792mutates
mutes75033782m_utes
mutter84418882mutter
mutters94117142mutters
mutts75120252mutt_s
notates72817482notates
notes55034582no_tes
otter54423972_otter
otters64021512_otters
ottos54714322_ottos
pontes83627852pontes
potted94624012potted
potter83926982potter
potters94024342potters
potties93723542potties
pottles93816982pottles
pottos84615872pottos
rotates72819772rotates
rotes56143902ro_tes
rotte54625932rotte_
rotted74524432rotted
rotten64115432rotten
rotter64325462rotter
rotters74421392rotters
routes66129312routes
sotted74121402sotted
tortes64826052tortes
totes55139682to_tes
totted74319952totted
totter65021462totter
totters74618732totters
voltes94915582voltes
votes84627082vo_tes
wotted104115712wotted

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.530337152.8
2DLD Change Limit825511552.26636430.3
3Display Results1551550.0632460.3
 (SQL Overall)1786911552.85962501.2
 
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.