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

250 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
tram6703455(None) 
cram85635491cram
dram75832001dram
gram77034581gram
pram85733491pram
ram56867271_ram
tam58663421t_am
team66238651team
trad55630911trad
tramp96319771tramp
trams75327671trams
trap67532801trap
tray77632591tray
trim65329521trim
am411875562__am
arak86929582arak
arame75026632arame
arm58449632ar_m
arum66129032arum
bam78560142_bam
barm86739612barm
beam86939232beam
blam86131702blam
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
bream95121812bream
brim85629372brim
cam78058982_cam
cham115532312cham
clam86332292clam
crab85727672crab
crag75625302crag
cramp115120692cramp
crams96229152crams
crap85731842crap
craw97725262craw
cream95721352cream
dam67457042_dam
diram84419472diram
drab76226452drab
drag64825052drag
drama85117432drama
drams86025832drams
drat56247832drat
draw85623012draw
dray85428092dray
dream85120392dream
drum76521592drum
era35741502era_
eras45441502eras
exam132514622exam
farm95934542farm
flam96333292flam
foam97127172foam
foram105124932foram
frae75330472frae
frag85126272frag
frame105821802frame
frap95925812frap
frat75648542frat
fray105428902fray
from96923922from
gam67060062_gam
glam76529342glam
grab75427612grab
grad66829862grad
grama85620292grama
gramp106218322gramp
grams85327312grams
gran56335012gran
grat55651282grat
gray85329892gray
grim76929422grim
grum75625082grum
ham86363282_ham
harm95637802harm
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
steam76322932steam
strap77925262strap
straw813321292straw
stray88525572stray
stream84717292stream
strum75619452strum
swam96329982swam
ta211662452t_a_
tab57460322t_ab
tad47959832t_ad
tae38267052t_ae
tag47259502t_ag
taj106442192t_aj
tame66343662t_ame
tamp86133012t_amp
tams67247932t_ams
tan37167582t_an
tao38358952t_ao
tap57663882t_ap
tar37570692t_ar
tarama8412742tarama
tare45957622tare
tarn46842722tarn
taro46846912taro
tarp66936422tarp
tars46763952tars
tart47566182tart
tas38477102t_as
tat37690292t_at
tau36856902t_au
tav66043212t_av
taw610155452t_aw
tax109449152t_ax
tea37353322tea_
teak85930842teak
teal45546502teal
teams75726512teams
tear45242882tear
teas45851492teas
teat45963632teat
teem66132602teem
terai53525482terai
term66233152term
thae76825562thae
than76128772than
tharm105916642tharm
that75639322that
thaw107521312thaw
them97427042them
thiram1139962thiram
thraw1110515922thraw
thrum104713632thrum
toad55830182toad
tom514358052t_om
toom66532932toom
tora47545992tora_
torah87125272torah
toras55540372toras
trace75829612trace
track114823012track
tract75635712tract
trade65026042trade
tragi64717172tragi
traik95418202traik
trail55126772trail
train56529112train
trait56940842trait
tramel84113712tramel
tramps105114452tramps
trampy13499252trampy
trank96222422trank
tranq145416892tranq
trans54933042trans
traps75727482traps
trapt76433392trapt
trash86119762trash
trass56226472trass
trauma838802trauma
trave85223032trave
trawl84915872trawl
trays85623432trays
tread64821702tread
treat56240352treat
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trey77228792trey
triac74116372triac
triad65217722triad
trial54926352trial
trig55528162trig
trims75021472trims
trio45233342trio
trip66830392trip
troak95213572troak
trod57627952trod
trog57628212trog
tromp95815802tromp
trop66833302trop
trot46351312trot
trow78031422trow
troy77429682troy
true46725852true
trug55720042trug
trump95615122trump
try66529672tr_y
tryma1037222tryma
tsar47819802tsar
twa67721642twa_
twae74719572twae
twas76824082twas
twat75831512twat
tzar136315372tzar
warm95935682warm
wham125321692wham
wrap96821972wrap
yam87448992_yam
ziram163912892ziram

Search took 6 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.576310227.4
2DLD Change Limit298722504.2966953.4
3Display Results2502500.1261984.1
 (SQL Overall)1786912504.99835752.5
 
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.