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

213 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
mover10422086(None) 
cover105430771cover
hover115524131hover
lover85526451lover
moper94925921moper
move96630721move_
moved114218151moved
movers115117191movers
moves106128421moves
mower104523451mower
over77227341_over
rover85527371rover
aiver85725162aiver
aver75931882_aver
boner75133082boner
borer75131272borer
bower107328182bower
boxer145016522boxer
caver105629062caver
clover114617122clover
coder86134212coder
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
cove95837072cove_
coved115027372coved
coven106925042coven
covers114627962covers
covert114925502covert
coves105539172coves
covet105638942covet
covey136121782covey
cower104531772cower
coyer105222842coyer
diver94827802diver
doer57734702do_er
doper86128392doper
doser66228562doser
doter65428622doter
dove85131562dove_
doven94718552doven
doves94728152doves
dower95027702dower
dozer158419272dozer
drover104614592drover
elver85216242elver
emoter85415192emoter
ever77027692_ever
fever115617952fever
fiver116024942fiver
fovea11310482fovea
foyer116416552foyer
giver94921202giver
glover104513532glover
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025152goner
govern1036822govern
haver115124462haver
hoer76533982ho_er
homer105828452homer
honer85332092honer
hoover124314432hoover
hoper105829142hoper
hoser811529762hoser
hove107132222hove_
hovel115017682hovel
hovers124320252hovers
jiver155119052jiver
joker165715892joker
laver85031792laver
lever85125162lever
liver85132962liver
loner55431032loner
loper75129232loper
loser54728672loser
louver94110392louver
love75234762love_
loved95021362loved
lovers94223432lovers
loves85332012loves
lower85830412lower
macer912126942macer
maker114127812maker
maser75029972maser
mater74438862mater
maven104816892maven
mazer165722422mazer
merer75126232merer
meter75130322meter
miler75733062miler
mimer94825762mimer
miner76933542miner
miser75430402miser
miter75734792miter
mixer145017642mixer
moaner84415112moaner
mobber123613462mobber
mocker143315442mocker
mode75840302mode_
model84521692model
modem103717142modem
modern939522modern
modes85537412modes
mohel104914832mohel
mohur1036512mohur
moiler84017262moiler
moire71017312moire
moke106234222moke_
mokes114631032mokes
molar75223092molar
molder93819272molder
mole66251832mole_
moles74747922moles
molter84119422molter
mome85239352mome_
momes95134472momes
momser104011412momser
momzer19327552momzer
money104826842money
monger94418332monger
mooed85123982mooed
mooner85317832mooner
moor66628552mo_or
mooter83921092mooter
mope86838042mope_
moped105424732moped
mopers104220372mopers
mopery135210972mopery
mopes95134982mopes
mopey124821822mopey
mopier103914782mopier
mopper126215002mopper
mor56855002mo__r
more67154522more_
morel75729092morel
mores76249642mores
mosey105922872mosey
mosher114719792mosher
mosser84618272mosser
mote67048082mote_
motel76623242motel
motes75944002motes
motet75641192motet
motey105922952motey
mother113718642mother
motor75317292motor
moue65835572moue_
moues75732842moues
mouser85822442mouser
movie105319132movie
movies115118452movies
mowed113629012mowed
mowers113219402mowers
muser76024122muser
muter74525542muter
never86218642never
noter55025642noter
novel85615992novel
omber95316432omber
omer67028392_omer
oven76624142_oven
overs85224792_overs
overt85630722_overt
oyer75927652_oyer
paver104225832paver
plover115312612plover
poker115122882poker
poler74431792poler
poser75128772poser
power105325952power
prover113819722prover
raver85631492raver
remover124612272remover
river85731692river
roger64521412roger
roper75431912roper
rove75136982rove_
roved95323552roved
roven85521972roven
rovers95423522rovers
roves84834482roves
rower85430492rower
saver84831252saver
sever85426052sever
shover124515982shover
siver85728612siver
smoker124311692smoker
sober74822402sober
soever94412092soever
solver94016702solver
sorer56236572sorer
sower85229312sower
stover94115642stover
toker95924912toker
toner55336242toner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
trover95014662trover
vomer105517382vomer
voter85121052voter
vower115220792vower
waver115025702waver
wiver115924512wiver
wolver12419712wolver
wooer84316692wooer
wove105624312wove_
woven115215172woven
zoner144520342zoner

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.0931921408.6
2DLD Change Limit538002131.61033416.1
3Display Results2132130.0633381.0
 (SQL Overall)1786912131.766101184.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.