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

294 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
loner5543103(None) 
boner75133081boner
cloner84418091cloner
goner66025151goner
honer85332091honer
liner55938911liner
loaner64416501loaner
lone45849131lone_
loners64225801loners
longer75823191longer
loper75129231loper
loser54728671loser
lover85526451lover
lower85830411lower
toner55336241toner
zoner144520341zoner
aliner65621982aliner
almner85710722almner
almoner949382almoner
alone55732962alone_
atoner64817192atoner
biner75930692biner
blonder104011942blonder
blower115316572blower
bonder95324782bonder
bone65949322bone_
boned85133242boned
boners84825432boners
bones76446532bones
boney105227312boney
bonier84321992bonier
bonzer175313672bonzer
borer75131272borer
bower107328182bower
boxer145016522boxer
caner75334772caner
clone75728162clone_
cloned94518802cloned
cloners94514822cloners
clones84526562clones
closer84918202closer
clover114617122clover
coder86134212coder
coiner84323782coiner
comer95832692comer
cone67256962cone_
coned86040052coned
cones76457422cones
coney105932882coney
confer114018682confer
conger95024272conger
conker124721552conker
conner84423962conner
cooer74831012cooer
coper95336092coper
corer75538872corer
corner84625622corner
cover105430772cover
cower104531772cower
coyer105222842coyer
diner65632902diner
doer57734702do_er
done55747912done_
donee66931012donee
donor64418192donor
doper86128392doper
doser66228562doser
doter65428622doter
dower95027702dower
downer104414922downer
dozer158419272dozer
droner74717672droner
eloiner7149182eloiner
eloper85414152eloper
finer85431562finer
flower124815502flower
fonder104120062fonder
foyer116416552foyer
glover104513532glover
glower105114932glower
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
gone55639042gone_
gonef95221292gonef
goners74420162goners
hoer76533982ho_er
homer105828452homer
hone77549322hone_
honed95332262honed
honers94324972honers
hones88144492hones
honey115629912honey
honker134117462honker
honor85718622honor
hoper105829142hoper
hoser811529762hoser
hover115524132hover
inner54920622inner
ironer64216442ironer
joiner134114132joiner
joker165715892joker
jones125028182jones
kroner104612572kroner
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
lancer84319972lancer
lander74028482lander
lane45153322lane_
lanes54946792lanes
lanker104123002lanker
lanner64920592lanner
laser54633322laser
later54843922later
laver85031792laver
laxer125420332laxer
layer84626472layer
leaner64022192leaner
leer46239352l_eer
leger65721502leger
lender73921272lender
lenes54738522lenes
leone55018822leone_
leones64417722leones
leper74820742leper
lever85125162lever
liber74723612liber
lier45942462l_ier
lifer85822152lifer
liger65024462liger
liker95627062liker
limner84112862limner
line46965572line_
linear65113332linear
lined64934642lined
linen55728722linen
liners65428842liners
lines57054572lines
liney87029622liney
linger75225992linger
linier64423782linier
linker104321462linker
linter64625332linter
liter54736342liter
liver85132962liver
loader74316302loader
loafer93610942loafer
loaned73816292loaned
loaners73913622loaners
lobar7313012lobar
lobber104016592lobber
lobe65535362lobe_
lobed86022132lobed
lobes75331002lobes
locker124019422locker
lode56240112lode_
loden66621142loden
lodes66436912lodes
lodger86517682lodger
lofter94614722lofter
loge56837192loge_
loges66534202loges
logger86420002logger
logier75015732logier
loiter64619172loiter
loller63315282loller
lonely92912462lonely
long56933342lon_g
longe66626462longe
longed87121372longed
longers84819532longers
longes75925572longes
longs65527062longs
looed64626132looed
looey84822912looey
looker104816952looker
looney94712402looney
loonier73312672loonier
looper83817112looper
looser65219942looser
looter64222322looter
lope65941922lope_
loped85128332loped
lopers84424142lopers
lopes76437342lopes
lopper103717202lopper
lore45850352lore_
lores55045402lores
loriner7511882loriner
lose45144582lose_
losel54419422losel
losers65123582losers
loses56742012loses
lotter64025602lotter
louder74414602louder
lounger84610212lounger
lour45430682lo_ur
louver94110392louver
love75234762love_
loved95021362loved
lovers94223432lovers
loves85332012loves
lowe75435312lowe_
lowed95233902lowed
lowers94624922lowers
lowery124112702lowery
lowes85732462lowes
loxed135017052loxed
loxes125227472loxes
luger65322082luger
lunar57017312lunar
lune47140492lune_
lunes55337772lunes
lunet56835422lunet
lunger75720412lunger
lunier64617602lunier
lunker104718342lunker
lurer54625312lurer
miner76933542miner
moaner84415112moaner
money104826842money
monger94418332monger
mooner85317832mooner
moper94925922moper
mover104220862mover
mower104523452mower
none45743172none_
nones55639132nones
nonet54540842nonet
noter55025642noter
older65121172older
omer67028392_omer
one37050912_one_
onery8414112_onery
ones46146532_ones
over77227342_over
owner84613312owner
oyer75927652_oyer
planer84122652planer
plover115312612plover
plower114315062plower
poker115122882poker
poler74431792poler
ponder94521692ponder
pone65747532pone_
pones74547042pones
poser75128772poser
power105325952power
roger64521412roger
roper75431912roper
rover85527372rover
rower85430492rower
saner54334322saner
sloper84615912sloper
slower94016152slower
sober74822402sober
sonar56523422sonar
sonder73623522sonder
sone46649982sone_
sones55444142sones
sooner64220462sooner
sorer56236572sorer
sorner64720382sorner
sower85229312sower
stoner65823202stoner
toker95924912toker
tone46953742tone_
toned65435342toned
toners64128002toners
tones56048662tones
toney86027412toney
tonger74719682tonger
tonier65520712tonier
tonner64819202tonner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
tuner56022682tuner
vomer105517382vomer
voter85121052voter
vower115220792vower
wonder103617812wonder
wonner95114442wonner
wooer84316692wooer
yonder103214132yonder
yonker134110852yonker
zone135231082zone_
zoned154020262zoned
zoners155115992zoners
zones145528042zones

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 Filter178691538000.0931921408.6
2DLD Change Limit538002941.81029723.8
3Display Results2942940.0963062.5
 (SQL Overall)1786912941.99989390.2
 
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.