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

184 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
moose7632719(None) 
goose65925901goose
loose56627681loose
moos66051301moos_
morose85116241morose
morse76032701morse
mouse77133001mouse
noose55624061noose
roose56127091roose
arose55832082arose
boos67955032boos_
boost75132472boost
booze164718912booze
bouse75931852bouse
bowse105420632bowse
brose75227032brose
choose115116142choose
chose105925402chose
close76425222close
comose105016842comose
cooee74531022cooee
coos67456492coos_
copse95623922copse
corse75036182corse
dose56442432_dose
douse66329722douse
dowse96020812dowse
erose55727272erose
fosse86119462fosse
goos57644912goos_
goosed86817032goosed
gooses75723052gooses
goosey105913512goosey
goosy96018882goosy
gorse65926812gorse
hoise85224772hoise
horse86132652horse
hose76547242_hose
house89131422house
impose103113052impose
jocose1537102jocose
looie55624242looie
loos49051122loos_
loosed75520892loosed
loosen66615962loosen
looser65219942looser
looses67328242looses
lose45144582_lose
louse56131012louse
lowse87219902lowse
manse75528232manse
marse76231152marse
masse75125292masse
mense75025632mense
mhos95517772mhos_
mioses84318852mioses
mise66043582m_ise
moas65545342moas_
mobs85737372mobs_
mocs85834902mocs_
mode75840302m_ode
modes85537412modes
mods77945052mods_
mogs75439332mogs_
moire71017322moire
moist76033582moist
mojoes15399522mojoes
mojos145314462mojos_
moke106234222m_oke
mokes114631032mokes
mole66251832m_ole
moles74747922moles
mols65948572mols_
mome85239352m_ome
momes95134472momes
moms86539482moms_
momser104011412momser
monde85723142monde
monie75631652monie
monos75930862monos_
mons68152262mons_
monte75829772monte
moo58460512moo__
mooch125313612mooch
mood76332062moo_d
moods85224622moods
moody115017492moody
mooed85123982mooed
mool67533862moo_l
moola75117032moola
mooley11311632mooley
mools76027172mools
moon67140812moo_n
mooned94216642mooned
mooner85317832mooner
moons75331002moons
moonset92413042moonset
moony104818272moony
moor66628552moo_r
moored93814172moored
moors74923142moors
moory105115792moory
moot67653622moo_t
mooted94120372mooted
mooter83921092mooter
moots75831662moots
mope86838042m_ope
mopes95134982mopes
mopoke1436632mopoke
mops85940132mops_
morae75831192morae
more67154522m_ore
mores76249642mores
mors65950062mors_
morsel85815892morsel
mos57067122m_os_
mosey105922872m_osey
mosh95227602m_osh
mosk105622442m_osk
moss67641032m_oss
mossed94818892mossed
mosser84618272mosser
mosses85527682mosses
mosso74715182mosso
mossy105217062mossy
most66554202m_ost
moste75925082moste
mote67048082m_ote
motes75944002motes
mots66853162mots_
motte75526972motte
moue65835572m_oue
moues75732842moues
moused94423302moused
mouser85822442mouser
mouses85531422mouses
mousey115216192mousey
mousse84813032mousse
mousy106716942mousy
move96630722m_ove
moves106128422moves
movie105319132movie
mows96340832mows_
moxie144018122moxie
mozos165516332mozos_
mucose10149312mucose
muse67136032m_use
myope124010972myope
myoses114013842myoses
nodose738882nodose
noise55723732noise
noosed75018012noosed
nooser65517822nooser
nooses65623642nooses
nose46739362_nose
ooze136420602_ooze
ose38147342__ose
owse76321622_owse
poise75127892poise
poos65949112poos_
poove104514302poove
porose84818742porose
pose66441732_pose
posse74722272posse
prose75835122prose
roosed75621592roosed
rooser63921882rooser
rooses65526232rooses
roost55730932roost
rose46148902_rose
rouse56634702rouse
smoosh11236732smoosh
souse56530772souse
those85218142those
torose64317692torose
torse55833332torse
touse55430672touse
vamoose1235862vamoose
whose114914532whose
woos76238802woos_
woosh113710732woosh
worse86525262worse
youse85322232youse
zoos135828802zoos_

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.310576422.6
2DLD Change Limit538001841.55034709.7
3Display Results1841840.0464000.0
 (SQL Overall)1786911841.90693751.8
 
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.