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

176 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
norms7601931(None) 
corms95626221corms
dorms85723841dorms
forms105327051forms
gorms85619591gorms
noms65636401no_ms
noris54928271noris
norm66429811norm_
worms105320761worms
arms66137492_arms
barms96128462barms
berms95323662berms
booms95427122booms
boras75938302boras
bores76448252bores
borks115727702borks
borts76735452borts
cords86030622cords
cores76361852cores
corks116028272corks
corm85735382corm_
corns76034762corns
corps95927042corps
cors66656442cor_s
derms85022892derms
doms76239572do_ms
dooms85321342dooms
dorks105724442dorks
dorm76834632dorm_
dormy115817472dormy
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doums85417642doums
enorm74415642enorm_
farms106324952farms
firms105217422firms
foams105017952foams
forams115115912forams
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
form95836872form_
forme105225992forme
formes114623712formes
forts86034452forts
forums114611842forums
germs85118872germs
gores65740372gores
gorm75529392gorm_
gorps85316992gorps
harms106829012harms
herms105626432herms
holms105117802holms
horas86333102horas
horns86125332horns
inarms8410092inarms
informs1248072informs
jorams154810532jorams
jorums15408092jorums
koras95927112koras
korma115913072korma
kormas124511232kormas
kors85933012kor_s
loams75619862loams
looms75124642looms
lords64923502lords
lores55045402lores
loris55329152loris
moms86539482mo_ms
moras76438782moras
mores76249642mores
morns75527442morns
mors65950062mor_s
morts75533562morts
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
neems77316292neems
nerds65719252nerds
nerts55924982nerts
neums75414252neums
nims66226882n_ims
nobs66436902no_bs
nocks115121012nocks
nodes64633492nodes
nods55838222no_ds
nodus66315992nodus
noels56418702noels
noes45845392no_es
noggs75811182noggs
nogs56534612no_gs
noils55024332noils
noirs55615462noirs
nolos54423352nolos
nom510450642no_m_
noma67529462no_ma
nomas74726412nomas
nome66038422no_me
nomes74933122nomes
nomos75919742nomos
nonas55126652nonas
nones55639132nones
nooks95420392nooks
noons54125282noons
nor38048822nor__
nori47133142nor_i
noria55722182noria
norias65518202norias
normal83213532normal
normals92510902normals
normed95014542normed
north86018272north
norths96812322norths
nos38859322no__s
noses55435642noses
notes55034582notes
nouns56717312nouns
nous46136982no_us
novas85215362novas
nows75738232no_ws
nowts86915862nowts
nurds65518522nurds
nurls55519682nurls
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
snores64324322snores
snorts64116502snorts
soms66239372so_ms
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorns55028422sorns
sorts54536662sorts
sorus54527582sorus
storms85814632storms
terms75523472terms
toms68343492to_ms
toras55540372toras
torcs75123762torcs
tores55352672tores
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torts56138122torts
torus54329762torus
unarms839242unarms
warms107726852warms
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.296603685.8
2DLD Change Limit538001761.42337807.4
3Display Results1761760.0463826.1
 (SQL Overall)1786911761.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.