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

141 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
motet7564119(None) 
mote67048081mote_
motel76623241motel
motes75944001motes
motets84216191motets
motey105922951motey
mott66648441mot_t
motte75526971motte
botel75121862botel
bott66548572bot_t
comet95946072comet
coset75748842coset
cote66648732cote_
coted85033852coted
cotes76347842cotes
covet105638942covet
dote55442882dote_
doted75227072doted
doter65428622doter
dotes65836692dotes
emote75421192emote_
emoted94614922emoted
emoter85415192emoter
emotes84620282emotes
godet7530042godet
hotel85520752hotel
lotte54923852lotte
mate65154222mate_
mated85537782mated
mater74438862mater
mates75251362mates
matey107022662matey
matt65752662mat_t
matte75626842matte
meet65350552m_eet
met56072432m__et
mete64438132mete_
meted85424432meted
meter75130322meter
metes74736212metes
mite66249412mite_
miter75734792miter
mites75141802mites
mitt66145492mit_t
moat66352032mo_at
moated94819002moated
mode75840302mode_
model84521692model
modem103717142modem
modes85537412modes
modest93818452modest
mohel104914832mohel
moiety1148222moiety
moist76033582moist
moke106234222moke_
mokes114631032mokes
mole66251832mole_
moles74747922moles
molest85022742molest
molt66356162mo_lt
molted94217472molted
molten83311812molten
molter84119422molter
mome85239352mome_
moment103319682moment
momes95134472momes
money104826842money
monte75829772monte_
montes84226932montes
mooed85123982mooed
moot67653622mo_ot
mooted94120372mooted
mooter83921092mooter
mope86838042mope_
moped105424732moped
moper94925922moper
mopes95134982mopes
mopey124821822mopey
moppet126915092moppet
more67154522more_
morel75729092morel
mores76249642mores
mort66758832mo_rt
mosey105922872mosey
most66554202mo_st
moste75925082moste_
mostest9314792mostest
mot57279422mo__t
motels83616902motels
moth96731332mot_h
mother113718642mother
moths106021552moths
mothy136214552mothy
motif10519682motif
motley1139382motley
motmot10311072motmot
motor75317292motor
mots66853162mot_s
mottes85523692mottes
motto76119512motto
motts76527002motts
moue65835572moue_
moues75732842moues
moult74728722moult
mount74128062mount
move96630722move_
moved114218152moved
mover104220862mover
moves106128422moves
mowed113629012mowed
mower104523452mower
mute65136872mute_
muted85023382muted
muter74525542muter
mutes75033782mutes
mutest84218052mutest
mutt65739402mut_t
nonet54540842nonet
note46239962note_
noted65123842noted
noter55025642noter
notes55034582notes
octet7324062octet
poet65552902po_et
potent84223352potent
roset55945242roset
rote46249022rote_
rotes56143902rotes
rotte54625932rotte
smote75820282smote_
stet45947322_stet
tet39274992__tet
tote46643672tote_
toted64929482toted
totem74819372totem
toter55932132toter
totes55139682totes
vote74728622vote_
voted93919142voted
voter85121052voter
votes84627082votes

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit538001411.60633499.4
3Display Results1411410.0334272.7
 (SQL Overall)1786911411.95291542.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.