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

258 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
trams7532767(None) 
crams96229151crams
drams86025831drams
grams85327311grams
prams96125511prams
rams65950771_rams
tams67247931t_ams
teams75726511teams
tram67034551tram_
tramp96319771tramp
tramps105114451tramps
trans54933041trans
traps75727481traps
trass56226471trass
trays85623431trays
trims75021471trims
araks94820882araks
arame75026622arame
arames84622572arames
arms66137492ar_ms
arums75517832arums
bams87044452_bams
barms96128462barms
beams95328172beams
blams95023852blams
brads85528292brads
braes75735052braes
brags85625102brags
brans75437432brans
bras65746452bra_s
brass75428022brass
brats75336012brats
braws106425192braws
brays106723112brays
breams104815042breams
brims94721622brims
cams87047282_cams
chams126028502chams
clams95127672clams
crabs95421392crabs
crags85622572crags
cram85635492cram_
cramp115120692cramp
cramps125615562cramps
craps95328642craps
crass76328042crass
craws105723122craws
creams104715252creams
dams77444372_dams
dirams94413702dirams
drabs85119672drabs
drags75521112drags
dram75832002dram_
drama85117412drama
dramas95814652dramas
drats66628372drats
draws95119372draws
drays95819772drays
dreams94513982dreams
drums85415872drums
eras45441502era_s
exams14199082exams
farms106324952farms
flams105125012flams
foams105017952foams
forams115115912forams
frags96322172frags
frame105821802frame
frames115119862frames
fraps105620552fraps
frass85321122frass
frats86829672frats
frays116920102frays
gams76648882_gams
glams85822932glams
grabs85719692grabs
grads75625752grads
gram77034582gram_
grama85620282grama
gramas94317202gramas
gramp106218322gramp
gramps114114272gramps
grans64832542grans
grass66125202grass
grays95621332grays
hams96446132_hams
harms106829012harms
ihrams1137172ihrams
imams91511112imams
jams135231072_jams
jorams154810532jorams
lams66552262_lams
loams75619862loams
ogams84112682ogams
orals55826482orals
pams85641762_pams
praams10459642praams
pram85733492pram_
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
prims95425932prims
proms95426412proms
rads56046602_rads
rags55448372_rags
rais45252622_rais
ram56867272_ram_
rami66034092_rami
ramp85934002_ramp
ramps96224632_ramps
ramus76418282_ramus
raps66247732_raps
ras37575392_ra_s
rats46260372_rats
raws75238212_raws
rays77642352_rays
reams75729622reams
rems66237722_rems
rims65936302_rims
roams74919612roams
roms67038962_roms
rums64833472_rums
scams94423972scams
scrams105216622scrams
seams75731662seams
shams105829412shams
slams74927902slams
spams94922192spams
steams84916902steams
straps87721782straps
strass67117222strass
straws98718672straws
strays96417932strays
streams94713372streams
strums84716452strums
tabs66842982t_abs
tads57143942t_ads
tags55545232t_ags
tam58663422t_am_
tame66343662t_ame
tames75242012t_ames
tamis76728732t_amis
tamp86133002t_amp
tamps95524082t_amps
tans46154822t_ans
taos45541002t_aos
taps66050672t_aps
tarama8412732tarama
taramas9612702taramas
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527112tarps
tars46763952t_ars
tarts57242022tarts
tas38477102t_a_s
tass45640572t_ass
tats46858132t_ats
taus46342732t_aus
tavs75630972t_avs
taws75641592t_aws
teaks94222902teaks
teals56234132teals
team66238652team_
tears55436462tears
teas45851492tea_s
teats55636812teats
teems76019782teems
terais64023512terais
terms75523472terms
tharms115712242tharms
thaws116515462thaws
thirams1236822thirams
thraws129211102thraws
thrums11429122thrums
toads65621072toads
toms68343492t_oms
torahs95115642torahs
toras55540372tora_s
trace75829612trace
traces85329932traces
track114823012track
tracks124818842tracks
tract75635712tract
tracts85019072tracts
trad55630912tra_d
trade65026042trade
trades75724502trades
tragi64717172tragi
tragus749232tragus
traik95418202traik
traiks104013712traiks
trail55126772trail
trails64622512trails
train56529112train
trains64725342trains
trait56940842trait
traits65121982traits
tramel84113712tramel
tramels93812492tramels
trampy13499252trampy
trank96222422trank
tranks104017762tranks
tranq145416892tranq
tranqs155210312tranqs
trap67532802tra_p
trapes85024462trapes
trapt76433392trapt
trash86119762trash
trauma838802trauma
traumas938592traumas
trave85223032trave
traves94222742traves
trawl84915872trawl
trawls94412392trawls
tray77632592tra_y
treads74817922treads
treats64821692treats
trees55835762trees
treks96016852treks
tres46542902tr_es
tress55423162tress
trets55928022trets
trews86118892trews
treys85018212treys
triacs83913222triacs
triads74513532triads
trials64319882trials
tries55742812tries
trigs65423062trigs
trim65329522trim_
trios55528092trios
trips74923362trips
troaks104410602troaks
trogs67022602trogs
trois57226092trois
tromp95815802tromp
tromps104911702tromps
trots56629942trots
trows88826182trows
troys86418612troys
trues54925322trues
trugs65516802trugs
trump95615122trump
trumps104611882trumps
truss54916922truss
tryma1037222tryma
tsars56717112tsars
twaes86513662twaes
twas76824082twa_s
twats86616602twats
tzars144914272tzars
warms107726852warms
whams135515642whams
wraps105617152wraps
yams95330732_yams
zirams17438642zirams

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.313570897.8
2DLD Change Limit538002581.42337807.4
3Display Results2582580.0763394.7
 (SQL Overall)1786912581.81298615.3
 
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.