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

219 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
loops7572396(None) 
bloops106611341bloops
coops96229641coops
goops86620961goops
hoops105621071hoops
loofs85623781loofs
looks95124861looks
looms75124641looms
loons55731721loons
loop67835011loop_
loopy105316641loopy
loos49051121loo_s
loots55431421loots
lops66043351l_ops
loups75319621loups
oops65232671_oops
poops94422411poops
sloops85513621sloops
woops104917521woops
bloods94614842bloods
blooms104613172blooms
bloop96116152bloop_
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boors74325012boors
boos67955032boo_s
boots75837972boots
bops86037982_bops
chops125019872chops
clomps125212232clomps
cloots85113692cloots
clops95924852clops
comps115526052comps
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coop87238652coop_
coopt95929852coopt
coopts105814582coopts
coos67456492coo_s
coots75636842coots
cops86751372_cops
corps95927042corps
coups95522472coups
crops96125232crops
dooms85321342dooms
doors65022132doors
dorps85419222dorps
droops95110962droops
drops85719502drops
floods104511652floods
floors94112352floors
flops105920142flops
foods95924162foods
fools86824202fools
foots85528282foots
fops96532682_fops
glooms96211682glooms
glops85619552glops
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goop75829482goop_
goopy115816622goopy
goos57644912goo_s
gorps85316992gorps
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoop96129982hoop_
hoots84830252hoots
hops97942632_hops
kloofs13386352kloofs
knops115911812knops
kooks85217262kooks
kops107031292_kops
lamps95624832lamps
laps66848872l_aps
leaps75522932leaps
limps95522672limps
lions55923212lions
lips67141442l_ips
lisps76913912lisps
loads65323372loads
loafs85616992loafs
loams75619862loams
loans56026462loans
lobes75331002lobes
lobos75921842lobos
lobs66441082l_obs
lochs106715512lochs
locks115126922locks
locoes85516582locoes
locos75822602locos
locus74819992locus
lodes66436912lodes
loess55714702loess
lofts85518362lofts
loges66534202loges
logons79818172logons
logos67225332logos
logs57343112l_ogs
loids66220702loids
loins56728422loins
lollops9227442lollops
lolls512121732lolls
longs65527062longs
loo38359822loo__
looby108115622looby
looed64626132looed
looey84822912looey
looeys95110122looeys
loof78141052loo_f
loofa85912812loofa
loofas9429832loofas
looie55624242looie
looies65025832looies
look87333472loo_k
lookups1332952lookups
loom67035052loo_m
loon47344792loo_n
loony86918962loony
looped95217172looped
looper83817112looper
loopers93914032loopers
loose56627682loose
looses67328242looses
loot46955822loo_t
lop58255312l_op_
lope65941922l_ope
lopes76437342lopes
loppy125911662loppy
lords64923502lords
lores55045402lores
loris55329152loris
loses56742012loses
loss45337962l_oss
lotas55926302lotas
lotos54724632lotos
lots47652092l_ots
lotus55718062lotus
louis57322322louis
loup66028432loup_
loupe75319512loupe
loupes84918052loupes
lours55125292lours
louts56330272louts
loves85332012loves
lowes85732462lowes
lows75843012l_ows
loxes125227472loxes
lumps95624982lumps
moods85224622moods
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302moo_s
moots75831662moots
mops85940132_mops
nooks95420392nooks
noons54125282noons
oohs75220692_oohs
oots46446442_oots
ops56641252__ops
plops95920332plops
pomps115316192pomps
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poop86532812poop_
poos65949112poo_s
pops86340952_pops
props95726882props
romps94617542romps
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
roups75118902roups
saloops93510132saloops
scoops105414362scoops
scops95820192scops
shops104222902shops
sloop76118912sloop_
slops75026012slops
snoops84314172snoops
soaps75120712soaps
sooks94425452sooks
soots55536212soots
sops65244562_sops
soups75322942soups
stoops85917892stoops
stops74827282stops
swoops114910922swoops
swops105913972swops
tools55325242tools
toons55027532toons
toots55331872toots
topos75726392topos
tops66248122_tops
troops85712782troops
whoops14487862whoops
whops135013932whops
woods95723032woods
woofs114918002woofs
wools84421462wools
woos76238802woo_s
wops96634152_wops
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.296603685.8
2DLD Change Limit538002191.40638264.6
3Display Results2192190.0633476.2
 (SQL Overall)1786912191.765101241.4
 
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.