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

220 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
dram7583200(None) 
cram85635491cram
dam67457041d_am
diram84419471diram
drab76226451drab
drag64825051drag
drama85117421drama
drams86025831drams
drat56247831drat
draw85623011draw
dray85428091dray
dream85120391dream
drum76521591drum
gram77034581gram
pram85733491pram
ram56867271_ram
tram67034551tram
am411875562__am
arak86929572arak
arame75026622arame
arm58449622ar_m
arum66129032arum
bam78560142_bam
barm86739602barm
beam86939232beam
blam86131702blam
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
bream95121812bream
brim85629372brim
cam78058982_cam
cham115532312cham
clam86332292clam
crab85727672crab
crag75625302crag
cramp115120692cramp
crams96229152crams
crap85731842crap
craw97725262craw
cream95721352cream
dab67455562d_ab
dad58456172d_ad
dag57753012d_ag
dah78148982d_ah
dak86340692d_ak
dal47554952d_al
dame77140312d_ame
damn75724322d_amn
damp96228842d_amp
dams77444372d_ams
dan46859672d_an
dap66652452d_ap
darb76033532darb
dare55848862dare
dark95133212dark
darn56434622darn
dart55857872dart
daw77148362d_aw
day76254112d_ay
dead65434242dead
deaf85838402deaf
deal56347412deal
dean56039482dean
dear55343602dear
deem75432892deem
derat65044082derat
deray95024182deray
derm76031892derm
derma84918512derma
dhak125512032dhak
dhal86719282dhal
dial55935072dial
dim68146502d_im
dirams94413702dirams
dirham12378272dirham
doat56947672doat
dom69752442d_om
doom76430072doom
dorm76834632dorm
doum76226672doum
drabs85119672drabs
drachm1436492drachm
draff125615662draff
draft95526682draft
drags75521112drags
drail65020972drail
drain65222892drain
drake104918302drake
dramas95814662dramas
drank104816202drank
drape85319632drape
drats66628372drats
drave95219272drave
drawl95516012drawl
drawn95614242drawn
draws95119372draws
drays95819772drays
dread74419022dread
dreams94513982dreams
dreamt94615712dreamt
dreamy12509992dreamy
drear65016902drear
dree56638322dree
dreg66821652dreg
drek96321092drek
drew86221672drew
drib76823262drib
drip76223952drip
drop75324402drop
drub75920132drub
drug65718132drug
drums85415872drums
dry76526032dr_y
dryad10477582dryad
drys86314802drys
duad66521412duad
dual55928172dual
duma75524452duma
dunam8313732dunam
dura55232112dura_
dural64923892dural
duras65727732duras
durum8513202durum
dyad96415452dyad
era35741502era_
eras45441502eras
exam132514622exam
farm95934532farm
flam96333292flam
foam97127172foam
foram105124932foram
frae75330472frae
frag85126272frag
frame105821802frame
frap95925812frap
frat75648542frat
fray105428902fray
from96923922from
gam67060062_gam
glam76529342glam
grab75427612grab
grad66829862grad
grama85620282grama
gramp106218322gramp
grams85327312grams
gran56335012gran
grat55651282grat
gray85329892gray
grim76929422grim
grum75625082grum
ham86363282_ham
harm95637792harm
ihram10310182ihram
imam81718332imam
jam126942522_jam
joram145816982joram
lam57666712_lam
loam65630482loam
nam55953392_nam
ogam75120032ogam
ora37250832ora_
orad56031692orad
oral47638122oral
pam77858392_pam
praam94815612praam
prams96125512prams
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
prim85132202prim
prom87631702prom
rad47662012_rad
rag45761322_rag
rah68052402_rah
rai37658222_rai
raj105740222_raj
rami66034092_rami
ramp85934002_ramp
rams65950772_rams
ran38266622_ran
rap56261962_rap
ras37575392_ras
rat37892742_rat
raw67252252_raw
rax108445722_rax
ray66361992_ray
ream65841612ream
rem56150042_rem
rim56052282_rim
roam67132412roam
rom59855632_rom
rum56644642_rum
scam85932352scam
scram910621622scram
seam66645972seam
sham96436362sham
slam67737972slam
spam85930042spam
swam96329982swam
tam58663422_tam
team66238652team
trad55630912trad
tramp96319772tramp
trams75327672trams
trap67532802trap
tray77632592tray
trim65329522trim
warm95935672warm
wham125321692wham
wrap96821972wrap
yam87448992_yam
ziram163912892ziram

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.283631417.0
2DLD Change Limit298722200.89033564.0
3Display Results2202200.0464782.6
 (SQL Overall)1786912201.219146588.2
 
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.