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

180 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
loofs8562378(None) 
coofs105924711coofs
goofs94821001goofs
hoofs115721041hoofs
kloofs13386351kloofs
loafs85616991loafs
loof78141051loof_
loofa85912811loofa
loofas9429831loofas
looks95124861looks
looms75124641looms
loons55731721loons
loops75723961loops
loos49051121loo_s
loots55431421loots
poofs105222791poofs
roofs85321151roofs
woofs114918001woofs
aloof83521572aloof_
bloods94614842bloods
blooms104613172blooms
bloops106611342bloops
boffs134915502boffs
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032boo_s
boots75837972boots
cloots85113692cloots
coffs134916302coffs
coifs105718702coifs
coof96643272coof_
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492coo_s
coots75636842coots
doffs125614332doffs
doofus1036162doofus
dooms85321342dooms
doors65022132doors
floods104511652floods
floors94112352floors
foods95924162foods
fools86824202fools
foots85528282foots
glooms96211682glooms
golfs95616102golfs
gonofs10459862gonofs
goods75124482goods
goof85436872goof_
goofy124915622goofy
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912goo_s
hoods95124082hoods
hoof106036582hoof_
hooks125027122hooks
hoops105621072hoops
hoots84830252hoots
howfs144814502howfs
kloof123812132kloof_
kooks85217262kooks
leafs85721182leafs
lions55923212lions
loads65323372loads
loaf76734902loaf_
loams75619862loams
loans56026462loans
lobes75331002lobes
lobos75921842lobos
lobs66441082l_obs
lochs106715512lochs
locks115126922locks
locoes85516582locoes
locos75822602locos
locus74819992locus
lodes66436912lodes
loess55714702loess
loft76539142l_oft
lofts85518362lofts
loges66534202loges
logons79818172logons
logos67225332logos
logs57343112l_ogs
loids66220702loids
loins56728422loins
lolls512121732lolls
longs65527062longs
loo38359822loo__
looby108115622looby
looed64626132looed
looey84822912looey
looeys95110122looeys
loofah12375812loofah
loofahs13364622loofahs
looie55624242looie
looies65025832looies
look87333472loo_k
loom67035052loo_m
loon47344792loo_n
loony86918962loony
loop67835012loo_p
loopy105316642loopy
loose56627682loose
looses67328242looses
loot46955822loo_t
lopes76437342lopes
lops66043352l_ops
lords64923502lords
lores55045402lores
loris55329152loris
loses56742012loses
loss45337962l_oss
lotas55926302lotas
lotos54724632lotos
lots47652092l_ots
lotus55718062lotus
louis57322322louis
loups75319622loups
lours55125292lours
louts56330272louts
loves85332012loves
lowes85732462lowes
lows75843012l_ows
loxes125227472loxes
luffs114516282luffs
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302moo_s
moots75831662moots
nooks95420392nooks
noons54125282noons
oafs76425262_oafs
offs107117012_offs
oohs75220692_oohs
oops65232672_oops
oots46446442_oots
poods85124752poods
poof95541662poof_
poofy136213272poofy
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poos65949112poo_s
poufs105616062poufs
profs105120892profs
proofs114511682proofs
rolfs84817122rolfs
roods65125282roods
roof75738832roof_
rooks95325042rooks
rooms75324682rooms
roots55933672roots
sloops85513622sloops
sooks94425452sooks
soots55536212soots
spoofs114011812spoofs
toffs116016722toffs
tools55325242tools
toons55027532toons
toots55331872toots
whoofs15457242whoofs
wolfs116214162wolfs
woods95723032woods
woof106532422woof_
wools84421462wools
woops104917522woops
woos76238802woo_s
zooks184716942zooks
zooms164415522zooms
zoons144919692zoons
zoos135828802zoo_s

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.300595636.7
2DLD Change Limit538001801.60633499.4
3Display Results1801800.0463913.0
 (SQL Overall)1786911801.95291542.5
 
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.