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

260 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
loons5573172(None) 
boons75031911boons
coons76737281coons
goons65326771goons
lions55923211lions
loans56026461loans
logons79818171logons
loins56728421loins
loofs85623781loofs
looks95124861looks
looms75124641looms
loon47344791loon_
loony86918961loony
loops75723961loops
loos49051121loo_s
loots55431421loots
moons75331001moons
noons54125281noons
poons75430971poons
toons55027531toons
zoons144919691zoons
aeons57624652aeons
agons66423782agons
aloins65022202aloins
axons125517932axons
azons146518252azons
bloods94614842bloods
blooms104613172blooms
bloops106611342bloops
boobs96221992boobs
books115729712books
booms95427122booms
boon67142172boon_
boors74325012boors
boos67955032boo_s
boots75837972boots
borons85520542borons
bosons85016652bosons
cions75222852cions
clons75228132clons
cloots85113692cloots
clowns114810112clowns
codons96119462codons
cogons96818112cogons
coins75834552coins
colons86028682colons
conns75024232conns
cons66057692_cons
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coon67248942coon_
coops96229642coops
coos67456492coo_s
coots75636842coots
corns76034762corns
croons85418422croons
dons56048702_dons
dooms85321342dooms
doors65022132doors
downs94918572downs
ebons74316092ebons
eloins65419382eloins
eons46638712_eons
exons125813342exons
floods104511652floods
floors94112352floors
fohns117310782fohns
foins85523382foins
fons76943892_fons
foods95924162foods
fools86824202fools
foots85528282foots
frons86124042frons
glooms96211682glooms
gluons738502gluons
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goon57236172goon_
goony95519782goony
goops86620962goops
goos57644912goo_s
gowns95115102gowns
hons77350782_hons
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoots84830252hoots
horns86125332horns
icons76516492icons
ikons96311012ikons
ions46737852_ions
irons55324132irons
johns15398712johns
joins125818412joins
kaons95014852kaons
kloofs13386352kloofs
koans95818622koans
kooks85217262kooks
kroons103711242kroons
lagoons839252lagoons
lawns85215422lawns
leans55536252leans
lemons84415052lemons
lenos56024862lenos
lens46146492l_ens
leone55018822leone
leones64417722leones
liens56525502liens
limns75718392limns
linns56123332linns
linos55631502linos
lins47059052l_ins
lion46334442lion_
loads65323372loads
loafs85616992loafs
loams75619862loams
loan47436452loan_
lobes75331002lobes
lobos75921842lobos
lobs66441082l_obs
lochs106715512lochs
locks115126922locks
locoes85516582locoes
locos75822602locos
locus74819992locus
lodens74315062lodens
lodes66436912lodes
loess55714702loess
lofts85518362lofts
logans76319062logans
loges66534202loges
logins77820642logins
logions86211292logions
logon615922312logon_
logos67225332logos
logs57343112l_ogs
loids66220702loids
loin46838722loin_
lolls512121732lolls
lone45849132l_one
long56933342l_ong
longs65527062longs
loo38359822loo__
looby108115622looby
looed64626132looed
looey84822912looey
looeys95110122looeys
loof78141052loo_f
loofa85912812loofa
loofas9429832loofas
looie55624242looie
looies65025832looies
looing73621042looing
look87333472loo_k
loom67035052loo_m
looney94712412looney
looneys10487012looneys
loonie64216452loonie
loonies73919542loonies
loop67835012loo_p
loopy105316642loopy
loose56627682loose
loosens716310952loosens
looses67328242looses
loot46955822loo_t
lopes76437342lopes
lops66043352l_ops
lorans65117602lorans
lords64923502lords
lores55045402lores
loris55329152loris
lorn46435252lorn_
loses56742012loses
loss45337962l_oss
lotas55926302lotas
lotions74614762lotions
lotos54724632lotos
lots47652092l_ots
lotus55718062lotus
louis57322322louis
loups75319622loups
lours55125292lours
louts56330272louts
loves85332012loves
lowes85732462lowes
lown76929292lown_
lows75843012l_ows
loxes125227472loxes
moans74624372moans
monos75930862monos
mons68152262_mons
moods85224622moods
mools76027172mools
moon67140812moon_
moony104818272moony
moors74923142moors
moos66051302moo_s
moots75831662moots
morns75527442morns
morons84919542morons
muons75816172muons
neons55818682neons
nooks95420392nooks
noon47134622noon_
nouns56717312nouns
onos46229002_onos
ons36148512__ons
oohs75220692_oohs
oops65232672_oops
oots46446442_oots
owns76819582_owns
peons75327182peons
phons105221142phons
pions75826392pions
pleons84213342pleons
pons65850602_pons
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poon67341262poon_
poops94422412poops
poos65949112poo_s
porns75527342porns
roans54926442roans
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
saloons74415322saloons
sloops85513622sloops
solons65120022solons
sons46049552_sons
sooks94425452sooks
soon46240502soon_
soots55536212soots
sorns55028422sorns
spoons84116022spoons
swoons94511142swoons
tons46553052_tons
tools55325242tools
toon47740632toon_
toots55331872toots
towns86018882towns
toyons95512132toyons
udons65411462udons
wons74942042_wons
woods95723032woods
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802woo_s
zooks184716942zooks
zooms164415522zooms
zoon137326982zoon_
zoos135828802zoo_s

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.296603685.8
2DLD Change Limit538002602.01326726.3
3Display Results2602600.1401857.1
 (SQL Overall)1786912602.44972964.9
 
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.