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

207 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
doors6502213(None) 
boors74325011boors
doers65225711doers
dolors75115311dolors
donors75115791donors
dooms85321341dooms
door56928511door_
dorrs65520591dorrs
dors56747601d_ors
moors74923141moors
odors64514281odors
boars75229602boars
boobs96221992boobs
books115729712books
booms95427122booms
boons75031912boons
boor66130682boor_
boos67955032boo_s
boots75837972boots
coirs75221052coirs
colors86622372colors
cooers84324562cooers
coofs105924712coofs
cooks115429142cooks
cools75632632cools
coons76737282coons
coops96229642coops
coos67456492coo_s
coots75636842coots
cors66656442_cors
dears65736882dears
decors94017772decors
deers64930522deers
dhoora1035652dhoora
dhooras1135942dhooras
dhows125911222dhows
diols65521012diols
doats65224882doats
dobra85013102dobra
dobras94811912dobras
dobro84412212dobro
dobros93910232dobros
docks126022312docks
docs75631152d_ocs
doctors1039992doctors
dodoes85716102dodoes
dodos75819392dodos
doer57734702doer_
does56554472d_oes
doffs125614332doffs
doges75630162doges
dogs66440152d_ogs
doits66223672doits
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dolor67617962dolor_
dolours8438822dolours
dols56943052d_ols
dolts65626312dolts
domes85735562domes
doms76239572d_oms
donas65926472donas
dongs76525812dongs
donor64418192donor_
dons56048702d_ons
doody105517912doody
doofus1036162doofus
dooly94821802dooly
doom76430072doo_m
doomy116018262doomy
doozers17419292doozers
doozy186813712doozy
dopas85019062dopas
dopers95522482dopers
dopes84935042dopes
dor47253922d_or_
dore56353302d_ore
dork96531462d_ork
dorks105724442dorks
dorm76834632d_orm
dorms85723842dorms
dorp76028052d_orp
dorps85419222dorps
dorr56627722d_orr
dorsa64617282d_orsa
dory85836232d_ory
dos48062312d_o_s
dosers75723632dosers
doses65938502doses
doss56235042d_oss
doters74423912doters
dotes65836692dotes
dots55647662d_ots
doums85417642doums
dour56330432dour_
doura66518662doura
douras75016722douras
doves94728152doves
dowers104523292dowers
downs94918572downs
dowry126312482dowry
dows85941052d_ows
dozers164815422dozers
dozes155226302dozes
drools74412812drools
droops95110962droops
drops85719502drops
dross65418092dross
duos56728132duo_s
duros65422692duros
durrs65519992durrs
dyers96617132dyers
floors94112352floors
foods95924162foods
fools86824202fools
foots85528282foots
fours85521492fours
goers65520252goers
goods75124482goods
goofs94821002goofs
gooks105422882gooks
goons65326772goons
goops86620962goops
goos57644912goo_s
hoars85925552hoars
hoers85724922hoers
honors94816792honors
hoods95124082hoods
hoofs115721042hoofs
hooks125027122hooks
hoops105621072hoops
hoots84830252hoots
hours85422392hours
indoors838552indoors
kooks85217262kooks
kors85933012_kors
loofs85623782loofs
looks95124862looks
looms75124642looms
loons55731722loons
loops75723962loops
loos49051122loo_s
loots55431422loots
lours55125292lours
moods85224622moods
mools76027172mools
moons75331002moons
moor66628552moor_
moory105115792moory
moos66051302moo_s
moots75831662moots
mors65950062_mors
motors84616602motors
noirs55615462noirs
nooks95420392nooks
noons54125282noons
oars46846032_oars
odor55718092odor_
odours7418252odours
oohs75220692_oohs
oops65232672_oops
oots46446442_oots
ors35750112__ors
ours47237562_ours
poods85124752poods
poofs105222792poofs
poohs103915712poohs
pools74427702pools
poons75430972poons
poops94422412poops
poor65630222poor_
poori74816232poori
pooris83916842pooris
poos65949112poo_s
pours74623182pours
roars55622242roars
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
rotors64917952rotors
soars54732512soars
sooks94425452sooks
soots55536212soots
sopors85215202sopors
sours55230502sours
spoors84014032spoors
tools55325242tools
toons55027532toons
toots55331872toots
toros54336192toros
torrs53923562torrs
tors46157382_tors
tours55325892tours
woods95723032woods
wooers93712442wooers
woofs114918002woofs
wools84421462wools
woops104917522woops
woos76238802woo_s
yours85217882yours
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 Limit538002071.58034050.6
3Display Results2072070.0603450.0
 (SQL Overall)1786912071.93692299.1
 
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.