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

208 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
damn7572432(None) 
dam67457041dam_
daman84821161daman
dame77140311dame
damns84916921damns
damp96228841damp
dams77444371dams
dan46859661da_n
darn56434621darn
dawn85624201dawn
adman84517902adman
admen84516182admen
ain37579092_ain
am411875562_am_
ama510853302_ama
amen66733152_amen
ami56646812_ami
amin66042252_amin
amp77541022_amp
amu58237322_amu
an211879072_a_n
awn68035912_awn
bam78560142bam_
bams87044452bams
ban58366832ba_n
barn66444642barn
bedamn1137812bedamn
cain65643912cain
cam78058982cam_
came87648752came
camo85731752camo
camp106336452camp
cams87047282cams
can57760132ca_n
carn66245432carn
dab67455562da_b
dabs77139402dabs
dace76934922dace
dad58456162da_d
dada66422442dada
dado67126332dado
dads67442772dads
daemon9279592daemon
daff115229682daff
daft85537252daft
dag57753002da_g
dago65725082dago
dags66642592dags
dah78148982da_h
dahl87019222dahl
dahs88231812dahs
daimen92210572daimen
daimon9259712daimon
dais57040702dais
dak86340692da_k
daks97130602daks
dal47554952da_l
dale55643982dale
dals57145122dals
damans94715982damans
damar84117732damar
dames85435852dames
damned104212912damned
damner95213432damner
dampen114310592dampen
damps105220412damps
damson938062damson
dang65131532dang
dank95828232dank
dans56748142dans
dap66652452da_p
daps77239162daps
darb76033532darb
dare55848862dare
dark95133212dark
darns66927892darns
dart55857872dart
dash87031632dash
data56026652data
date56443322date
dato56129942dato
daub77423442daub
daunt65929082daunt
daut56443562daut
daven94916472daven
davy116015522davy
daw77148362da_w
dawen95413722dawen
dawk126117282dawk
dawns95916592dawns
daws86638242daws
dawt85435942dawt
day76254112da_y
days87637132days
daze147327232daze
dean56039482dean
deme76536282deme
demo77427552demo
demon86520312demon
demy105422852demy
den47554342d_en
diamin9312512diamin
dim68146492dim_
dime76237642dime
dims75435022dims
din46459462d_in
djin12911632djin
dom69752442dom_
dome77240732dome
doms76239572doms
don46757652d_on
down86427492down
drain65222892drain
dram75832002dram_
drama85117412drama
drams86025832drams
drawn95614242drawn
duma75524452duma
dumb97124102dumb
dump95927092dump
dun46545582d_un
durn56127622durn
earn46737552earn
fain75840562fain
fame95639392fame
fan67158852fa_n
faun76226622faun
fawn105321952fawn
gaen57329602gaen
gain56042162gain
gam67060062gam_
gama77035512gama
gamb96331842gamb
game76644322game
gamin84422992gamin
gamp98833212gamp
gams76648882gams
gamy105427532gamy
gan48060122ga_n
gaun56427712gaun
haen76229452haen
ham86363282ham_
hame97043132hame
hams96446132hams
hymn12311312hymn
iamb86623732iamb
jam126942522jam_
jamb155523852jamb
jams135231072jams
kain85334292kain
kame105728232kame
kami105823642kami
kaon87521022kaon
karn86129412karn
lain46146282lain
lam57666712lam_
lama66635292lama
lamb86832142lamb
lame66849292lame
lamp86233822lamp
lams66552262lams
lawn75925632lawn
limn66527692limn
main65345512main
mama86231582mama
man57465852ma_n
maun65727202maun
mawn94424132mawn
naan47621932naan
nam55953392nam_
name65637412name
nan37854872na_n
pain65647242pain
pam77858392pam_
pams85641762pams
pan58466442pa_n
pawn94625302pawn
rain46251732rain
ram56867272ram_
ramen75625192ramen
rami66034092rami
ramp85934002ramp
rams65950772rams
ran38266612ra_n
sain45551292sain
same65245642same
samp85733592samp
sawn75428162sawn
tain45548072tain
tam58663422tam_
tame66343662tame
tamp86133002tamp
tams67247932tams
tan37167562ta_n
tarn46842722tarn
vain75233002vain
vamp115521542vamp
van66246322va_n
wain75840192wain
wame95035482wame
wan66761932wa_n
warn75239322warn
yam87448992yam_
yamen104115182yamen
yams95330732yams
yamun10419272yamun
yarn75230042yarn
yawn106219092yawn

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 Filter178691298720.0802233637.5
2DLD Change Limit298722080.95331345.2
3Display Results2082080.0464521.7
 (SQL Overall)1786912081.079165608.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.