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

185 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
moths10602155(None) 
goths96513001goths
maths105624021maths
meths105320231meths
months113812931months
motes75944001motes
moth96731331moth_
mothy136214551mothy
mots66853161mot_s
motts76527001motts
mouths115214531mouths
myths135911601myths
soths86218631soths
azoths18366202azoths
baths105922922baths
beths105519222beths
booths115313792booths
botas75328782botas
both96533432both_
bothy136713962bothy
bots66453952bot_s
botts75224862botts
broths115013922broths
cloths115512482cloths
cotes76347842cotes
cots68054842cot_s
couths115715412couths
dotes65836692dotes
doth86225712doth_
dots55647662dot_s
emotes84620282emotes
eths76619522_eths
froths125411442froths
goth86825082goth_
heths116317782heths
hots78349332hot_s
iotas54821112iotas
jotas125717442jotas
jots116336142jot_s
kiths125814972kiths
kophs145010932kophs
kotos95717702kotos
laths86022402laths
lochs106715512lochs
lotahs9479872lotahs
lotas55926302lotas
loth76132132loth_
lotos54724632lotos
lots47652092lot_s
lotus55718062lotus
machs125722562machs
mates75251362mates
math95437452math_
mats65460292mat_s
matts76829182matts
metes74736212metes
meth95827842meth_
metis75025902metis
mirths114912992mirths
mites75141802mites
mitis75425992mitis
mitts75523752mitts
moans74624372moans
moas65545342mo_as
moats75827642moats
mobs85737372mo_bs
mocha1249922mocha
mochas13310662mochas
mocks135023822mocks
mocs85834902mo_cs
modes85537412modes
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
moils76125752moils
mojos145314462mojos
mokes114631032mokes
molas75132092molas
molds85324832molds
moles74747922moles
molls75129782molls
mols65948572mo_ls
molts76032092molts
momes95134472momes
moms86539482mo_ms
momus96116112momus
monas74732152monas
monks116123392monks
monos75930862monos
mons68152262mo_ns
montes84226932montes
month104818422month_
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moots75831662moots
mopes95134982mopes
mops85940132mo_ps
moras76438782moras
mores76249642mores
morns75527442morns
morphs13149432morphs
mors65950062mo_rs
morts75533562morts
mos57067122mo__s
mosh95227602mosh_
moshes115222872moshes
mosks116117002mosks
moss67641032mo_ss
mosts76028542mosts
mot57279422mot__
mote67048082mot_e
motel76623242motel
motels83616892motels
motet75641192motet
motets84216192motets
motey105922952motey
mother113718642mother
mothers123717622mothers
motif10519682motif
motifs1139672motifs
motor75317292motor
motors84616602motors
mott66648442mot_t
motte75526972motte
mottes85523692mottes
motto76119512motto
mottos84615242mottos
moues75732842moues
mouth105420292mouth_
mouthy14409062mouthy
moves106128422moves
mows96340832mo_ws
moxas145014392moxas
mozos165516332mozos
musths11589482musths
mutes75033782mutes
muts64839982mut_s
mutts75120252mutts
myth126715432myth_
mythos14398462mythos
mythy16568672mythy
norths96812322norths
notes55034582notes
oaths86117312oaths
ohs66232312_o_hs
oohs75220692_oohs
oots46446442oot_s
paths105521382paths
piths105817542piths
poohs103915712poohs
pothos114214692pothos
pots66452362pot_s
qophs19507812qophs
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092rot_s
rouths95416822rouths
rowths12458172rowths
ruths85714642ruths
sloths94911892sloths
smiths114711022smiths
smooths12216322smooths
sooths95715592sooths
sophs104916022sophs
soth75932522soth_
sots45552452sot_s
souths95216602souths
teths85418512teths
tooths96013802tooths
tophs105220052tophs
totes55139682totes
tots46654122tot_s
troths95414152troths
votes84627082votes
worths127812892worths
wots76342892wot_s
yodhs12669012yodhs
yoghs125410592yoghs
youths124510042youths

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 Limit538001851.57634137.1
3Display Results1851850.0503700.0
 (SQL Overall)1786911851.93992156.3
 
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.