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

211 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
dorms8572384(None) 
corms95626221corms
derms85022891derms
doms76239571do_ms
dooms85321341dooms
dorks105724441dorks
dorm76834631dorm_
dormy115817471dormy
dorps85419221dorps
dorrs65520591dorrs
dors56747601dor_s
doums85417641doums
forms105327051forms
gorms85619591gorms
norms76019311norms
worms105320761worms
adores74420722adores
adorns74212612adorns
arms66137502_arms
barms96128472barms
berms95323662berms
booms95427122booms
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
cords86030622cords
cores76361852cores
corks116028272corks
corm85735382corm_
corns76034762corns
corps95927042corps
cors66656442cor_s
dams77444372d_ams
darbs85323262darbs
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
deems85421772deems
deforms1337802deforms
derm76031892derm_
derma84918522derma
dermas94116822dermas
dermis94717162dermis
deworms1338032deworms
dims75435032d_ims
dirams94413702dirams
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
doats65224882doats
dobras94811912dobras
dobros93910232dobros
docks126022312docks
docs75631152do_cs
dodos75819392dodos
doers65225712doers
does56554472do_es
doffs125614332doffs
doges75630162doges
dogma96112462dogma
dogmas105011242dogmas
dogs66440152do_gs
doits66223672doits
dojos135111792dojos
doles67843752doles
dolls66126922dolls
dolma86214172dolma
dolmas95213042dolmas
dols56943052do_ls
dolts65626312dolts
dom69752442do_m_
dome77240732do_me
domes85735562domes
donas65926472donas
dongs76525812dongs
dons56048702do_ns
doom76430072doom_
doomy116018262doomy
doors65022132doors
dopas85019062dopas
dopes84935042dopes
dor47253922dor__
dore56353302dor_e
dories75232362dories
dork96531462dor_k
dorky135518742dorky
dormer94415902dormer
dormers104313922dormers
dormie9312622dormie
dormin9312312dormin
dormins10311272dormins
dorp76028052dor_p
dorr56627722dor_r
dorsa64617282dorsa
dorty96220812dorty
dory85836232dor_y
dos48062312do__s
doses65938502doses
doss56235042do_ss
dotes65836692dotes
dots55647662do_ts
doum76226672doum_
douma85817702douma
doumas95314812doumas
douras75016722douras
doves94728152doves
downs94918572downs
dows85941052do_ws
dozes155226302dozes
drams86025832drams
drops85719502drops
dross65418092dross
drums85415872drums
drys86314802d_rys
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
durums948152durums
farms106324962farms
firms105217422firms
foams105017952foams
forams115115912forams
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
form95836872form_
forme105225992forme
formes114623712formes
forts86034452forts
forums114611842forums
germs85118872germs
gores65740372gores
gorm75529392gorm_
gorps85316992gorps
harms106829022harms
herms105626432herms
holms105117802holms
horas86333102horas
horns86125332horns
jorams154810532jorams
jorums15408092jorums
koras95927122koras
korma115913092korma
kormas124511252kormas
kors85933022kor_s
loams75619862loams
looms75124642looms
lords64923502lords
lores55045402lores
loris55329152loris
moms86539482mo_ms
moras76438782moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
noms65636402no_ms
noris54928272noris
norm66429812norm_
odors64514282odor_s
ohms95514032_ohms
oms56337512_o_ms
orbs66626252_orbs
orcs67025432_orcs
ores46056682_ores
ors35750112_or_s
orts46538332_orts
perms95524512perms
poems95715552poems
poms87037742po_ms
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
proms95426412proms
roams74919612roams
roms67038962ro_ms
rooms75324682rooms
soms66239372so_ms
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
storms85814632storms
terms75523472terms
toms68343492to_ms
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
warms107726862warms
words95425072words
works125621902works
worm96129492worm_
wormy137514252wormy
worts88631182worts
yores85031322yores
zooms164415522zooms
zoris145320012zoris

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.330541487.9
2DLD Change Limit538002111.42037887.3
3Display Results2112110.0464587.0
 (SQL Overall)1786912111.79699493.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.