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

271 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
loser5472867(None) 
closer84918201closer
doser66228561doser
hoser811529761hoser
laser54633321laser
loner55431031loner
looser65219941looser
loper75129231loper
lose45144581lose_
losel54419421losel
losers65123581losers
loses56742011loses
lover85526451lover
lower85830411lower
poser75128771poser
baser74828922baser
blower115316572blower
boner75133082boner
borer75131272borer
bosker123813652bosker
bower107328182bower
boxer145016522boxer
cloner84418092cloner
close76425222close_
closed95317962closed
closers94415312closers
closes85425592closes
closet85226602closet
clover114617122clover
coder86134212coder
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
cosec96320182cosec
coses76949492coses
coset75748842coset
cosey106226712cosey
cosher114819902cosher
cosier84423752cosier
coster84331292coster
cover105430772cover
cower104531772cower
coyer105222842coyer
doer57734702do_er
doper86128392doper
dorser74819172dorser
dose56442432dose_
dosed76626912dosed
dosers75723632dosers
doses65938502doses
dosser74417972dosser
doter65428622doter
douser75621632douser
dower95027702dower
dowser104716082dowser
dozer158419272dozer
eloper85414152eloper
flosser10339692flosser
flower124815502flower
foster94322222foster
foyer116416552foyer
glosser83410812glosser
glover104513532glover
glower105114932glower
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025152goner
hoer76533982ho_er
homer105828452homer
honer85332092honer
hoper105829142hoper
hose76547242hose_
hosed95830982hosed
hosel86024812hosel
hosen85623882hosen
hosers95223952hosers
hoses85443172hoses
hosey116127022hosey
hosier94219612hosier
houser95322282houser
hover115524132hover
joker165715892joker
josher164312962josher
kosher134412972kosher
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
lapser84113142lapser
lase46148512lase_
lased65132342lased
lasers64925702lasers
lases54944762lases
lasher94824532lasher
laster64830632laster
later54843922later
laver85031792laver
laxer125420332laxer
layer84626472layer
leaser65322672leaser
leer46239352l_eer
leger65721502leger
leper74820742leper
leses54930812leses
lesser63514852lesser
lever85125162lever
liber74723612liber
lier45942462l_ier
lifer85822152lifer
liger65024462liger
liker95627062liker
liner55938912liner
lisper84114432lisper
lister64527252lister
liter54736342liter
liver85132962liver
loader74316302loader
loafer93610942loafer
loaner64416502loaner
lobar7313012lobar
lobber104016592lobber
lobe65535362lobe_
lobed86022132lobed
lobes75331002lobes
lobster9288852lobster
locker124019422locker
lode56240112lode_
loden66621142loden
lodes66436912lodes
lodger86517682lodger
loess55714702loess
lofter94614722lofter
loge56837192loge_
loges66534202loges
logger86420002logger
logier75015732logier
loiter64619172loiter
loller63315282loller
lone45849132lone_
loners64225802loners
longer75823192longer
looed64626132looed
looey84822912looey
looker104816952looker
looper83817112looper
loose56627682loose_
loosed75520892loosed
loosen66615962loosen
looses67328242looses
looter64222322looter
lope65941922lope_
loped85128332loped
lopers84424142lopers
lopes76437342lopes
lopper103717202lopper
lore45850352lore_
lores55045402lores
losels64714582losels
loss45337962los_s
losses65925232losses
lossy85214642lossy
lost47951492los_t
lotter64025602lotter
louder74414602louder
lour45430682lo_ur
louse56131012louse_
loused74822912loused
louses66230282louses
lousier72411622lousier
louver94110392louver
love75234762love_
loved95021362loved
lovers94223432lovers
loves85332012loves
lowe75435312lowe_
lowed95233902lowed
lowers94624922lowers
lowery124112702lowery
lowes85732462lowes
lowse87219902lowse_
loxed135017052loxed
loxes125227472loxes
luger65322082luger
lurer54625312lurer
lusher93818762lusher
luster64023672luster
lyse76320592lyse_
lysed95011562lysed
lyses84518252lyses
maser75029972maser
miser75430402miser
momser104011412momser
moper94925922moper
mosey105922872mosey
mosher114719792mosher
mosser84618272mosser
mouser85822442mouser
mover104220862mover
mower104523452mower
muser76024122muser
nooser65517822nooser
nose46739362nose_
nosed65524552nosed
noses55435642noses
nosey85619882nosey
nosher94616362nosher
nosier63716322nosier
noter55025642noter
older65121172older
omer67028392_omer
osar46820952_osar
ose38147342_ose_
oses46641512_oses
osier53518012_osier
over77227342_over
oyer75927652_oyer
plover115312612plover
plower114315062plower
poiser84217242poiser
poker115122882poker
poler74431792poler
pose66441732pose_
posed85828412posed
posers84223972posers
poses74642762poses
poseur8419402poseur
posher115018162posher
poster84129172poster
power105325952power
proser84223462proser
raser55633412raser
riser55431052riser
roger64521412roger
rooser63921882rooser
roper75431912roper
rose46148902rose_
rosed65930342rosed
rosery93813282rosery
roses56445772roses
roset55945242roset
rosier64221262rosier
roster64329082roster
rouser65224082rouser
rover85527372rover
rower85430492rower
ser36752402__ser
sloper84615912sloper
slower94016152slower
sober74822402sober
sorer56236572sorer
sower85229312sower
toker95924912toker
toner55336242toner
toper75231022toper
tosser64215662tosser
toter55932132toter
tower85729202tower
toyer84521552toyer
user45023002_user
vomer105517382vomer
voter85121052voter
vower115220792vower
wiser85522802wiser
wooer84316692wooer
worser95117522worser
wowser125110202wowser
zoner144520342zoner
zoster153715852zoster

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 Limit538002711.58034050.6
3Display Results2712710.0763565.8
 (SQL Overall)1786912711.749102167.5
 
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.