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

187 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
movers11511719(None) 
covers114627961covers
hovers124320251hovers
lovers94223431lovers
mopers104220371mopers
mover104220861mover_
moves106128421move_s
mowers113219401mowers
overs85224791_overs
rovers95423521rovers
aivers94822322aivers
avers85127312_avers
boners84825432boners
borers85122682borers
bowers115523702bowers
boxers155013482boxers
cavers115026842cavers
clovers125114662clovers
coders95426982coders
comers105328082comers
cooers84324562cooers
copers104629842copers
corers85231072corers
covens114919262covens
cover105430772cover_
covert114925502covert
coverts124813812coverts
coves105539172cove_s
covets114819642covets
coveys145413502coveys
cowers114625532cowers
divers105024962divers
doers65225712do_ers
dopers95522482dopers
dosers75723632dosers
doters74423912doters
dovens104413902dovens
doves94728152dove_s
dowers104523292dowers
dozers164815422dozers
drovers115212642drovers
elvers93814982elvers
emoters94712872emoters
fevers125414892fevers
fivers124420922fivers
foveas1238622foveas
foyers125413132foyers
givers104817712givers
glovers114310882glovers
goers65520252go_ers
gofers104711512gofers
gomers94116882gomers
goners74420172goners
govern1036822govern
governs1136102governs
havers124721482havers
hoers85724922ho_ers
homers114821982homers
honers94324972honers
hoovers134312712hoovers
hopers114222972hopers
hosers95223972hosers
hovels125413342hovels
hover115524132hover_
jivers164515642jivers
jokers175511192jokers
lavers94526362lavers
levers94621322levers
livers94927822livers
loners64225812loners
lopers84424142lopers
losers65123582losers
louvers10359102louvers
lover85526452lover_
loves85332012love_s
lowers94624922lowers
macers105321272macers
makers123921732makers
masers84623452masers
maters85032392maters
mavens114312972mavens
mazers173917092mazers
meters85625832meters
milers84625162milers
mimers105520182mimers
miners84126632miners
misers85025702misers
miters84328782miters
mixers154513562mixers
moaners92813552moaners
mobbers133610922mobbers
mockers153812942mockers
models94216362models
modems114610762modems
modern939522modern
moderns1037962moderns
modes85537412mode_s
mohels115011332mohels
mohurs1135932mohurs
moilers93615202moilers
moires8915632moires
mokes114631032moke_s
molars85517322molars
molders103315552molders
moles74747922mole_s
molters93816972molters
momes95134472mome_s
momsers113810852momsers
momzers20367132momzers
moneys115513622moneys
mongers104217272mongers
mooners94015342mooners
moors74923142mo_ors
mooters93818622mooters
mopeds11499662mopeds
moper94925922moper_
mopery135210972mopery
mopes95134982mope_s
moppers133412462moppers
morels84820022morels
mores76249642more_s
mors65950062mo__rs
moseys114711712moseys
moshers124017842moshers
mossers94116192mossers
motels83616902motels
motes75944002mote_s
motets84216192motets
mothers123717622mothers
motors84616602motors
moues75732842moue_s
mousers95216442mousers
move96630722move__
moved114218152move_d
movies115118452movies
mower104523452mower_
musers84719102musers
noters64021002noters
novels95512502novels
ombers104214402ombers
omers76923192_omers
ovens86217452_ovens
over77227342_over_
overt85630722_overt
oyers87620882_oyers
pavers115021822pavers
plovers123611832plovers
pokers124617922pokers
polers84225642polers
posers84223972posers
powers113822322powers
provers123817792provers
ravers94628182ravers
removers13449222removers
revers94529632revers
rivers94626542rivers
rogers74517912rogers
ropers84325902ropers
rover85527372rover_
roves84834482rove_s
rowers94924572rowers
savers93825922savers
severs94121122severs
shovers134613002shovers
sivers95324152sivers
smokers13389322smokers
sobers85218862sobers
solvers104414252solvers
sowers94923442sowers
stovers103713732stovers
tokers104818892tokers
toners64128002toners
topers85025322topers
toters65026362toters
towers94423672towers
toyers95516332toyers
trovers103713322trovers
vivers124717362vivers
vomers115614942vomers
voters95017442voters
vowers124317182vowers
wavers125022472wavers
wivers125320802wivers
wolvers13349312wolvers
wooers93712442wooers
wovens12449832wovens
zoners155115992zoners

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 Limit825511872.51332849.6
3Display Results1871870.0632968.3
 (SQL Overall)1786911872.92261153.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.