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

244 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
trap6753280(None) 
crap85731841crap
frap95925811frap
rap56261961_rap
strap77925261strap
tap57663871t_ap
tarp66936411tarp
trad55630911trad
tram67034551tram
tramp96319771tramp
traps75727481traps
trapt76433391trapt
tray77632591tray
trip66830391trip
trop66833301trop
wrap96821971wrap
arak86929572arak
atap66722452atap
atrip75315752atrip
bap76455842_bap
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
bran65740382bran
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
cap76758982_cap
carp85139812carp
chap114928492chap
clap86429042clap
crab85727672crab
crag75625302crag
cram85635492cram
cramp115120692cramp
crape96128442crape
craps95328642craps
craw97725262craw
crop87628632crop
dap66652452_dap
drab76226452drab
drag64825052drag
dram75832002dram
drape85319632drape
drat56247832drat
draw85623012draw
dray85428092dray
drip76223952drip
drop75324402drop
entrap8710562entrap
era35741502era_
eras45441502eras
flap96128702flap
frae75330472frae
frag85126272frag
fraps105620552fraps
frat75648542frat
fray105428902fray
gap67055612_gap
grab75427612grab
grad66829862grad
gram77034582gram
gramp106218322gramp
gran56335012gran
grape84824662grape
graph115315612graph
grapy115416432grapy
grasp84814482grasp
grat55651282grat
gray85329892gray
grip76127022grip
hap87360052_hap
harp96134292harp
heap96432892heap
knap105815402knap
lap58565272_lap
leap66032682leap
map77255122_map
nap56753202_nap
neap66927012neap
ora37250832ora_
orad56031692orad
oral47638122oral
pap76758402_pap
pram85733492pram
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
prep86427672prep
prop85932812prop
rad47662002_rad
rag45761322_rag
rah68052402_rah
rai37658222_rai
raj105740222_raj
ram56867272_ram
ramp85934002_ramp
ran38266622_ran
rape65041632_rape
raps66247732_raps
rapt67245312_rapt
ras37575392_ras
rasp66029162_rasp
rat37892742_rat
raw67252252_raw
rax108445722_rax
ray66361992_ray
reap65934742reap
rep55847802_rep
rip56851302_rip
sap56463232_sap
satrap86212552satrap
scrap97120402scrap
slap66434042slap
snap65727032snap
soap65831132soap
straps87721782straps
straw813321292straw
stray88525572stray
strep77120852strep
strip77524342strip
strop77422242strop
swap95925432swap
ta211662452t_a_
tab57460322t_ab
tad47959822t_ad
tae38267052t_ae
tag47259492t_ag
taj106442192t_aj
tam58663422t_am
tamp86133002tamp
tan37167572t_an
tao38358952t_ao
tapa65129142t_apa
tape64538142t_ape
taps66050672t_aps
tar37570692t_ar
tare45957622tare
tarn46842722tarn
taro46846912taro
tarps76527112tarps
tars46763952tars
tart47566182tart
tas38477102t_as
tat37690292t_at
tau36856902t_au
tav66043212t_av
taw610155452t_aw
tax109449152t_ax
tea37353322tea_
teak85930842teak
teal45546502teal
team66238652team
tear45242882tear
teas45851492teas
teat45963632teat
temp85323332temp
tepa66021682tepa
terai53525482terai
teraph11319092teraph
thae76825562thae
than76128772than
that75639322that
thaw107521312thaw
thraw1110515922thraw
threap11569662threap
thrip103012182thrip
tip56551222t_ip
toad55830182toad
top510560682t_op
tora47545992tora_
torah87125272torah
toras55540372toras
trace75829612trace
track114823012track
tract75635712tract
trade65026042trade
tragi64717172tragi
traik95418202traik
trail55126772trail
train56529112train
trait56940842trait
tramps105114452tramps
trampy13499252trampy
trams75327672trams
trank96222422trank
tranq145416892tranq
trans54933042trans
trapan82412972trapan
trapes85024462trapes
trash86119762trash
trass56226472trass
trave85223032trave
trawl84915872trawl
trays85623432trays
tread64821702tread
treat56240352treat
tree47745812tree
tref77030992tref
trek86222312trek
tres46542902tres
tret46653532tret
trey77228792trey
triac74116372triac
triad65217722triad
trial54926352trial
trig55528162trig
trim65329522trim
trio45233342trio
tripe75425382tripe
trips74923362trips
troak95213572troak
trod57627952trod
trog57628212trog
tromp95815802tromp
troop76417532troop
trope75725802trope
trot46351312trot
trow78031422trow
troy77429682troy
true46725852true
trug55720042trug
trump95615122trump
try66529672tr_y
tsar47819802tsar
tump85927032tump
tup56037542t_up
twa67721642twa_
twae74719572twae
twas76824082twas
twat75831512twat
typp115812782typp
tzar136315372tzar
urp56426392ur_p
wap86553372_wap
warp95635002warp
whap125119642whap
wraps105617152wraps
wrapt105123182wrapt
yap85949822_yap
zap145840692_zap

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.280638182.1
2DLD Change Limit298722440.81336742.9
3Display Results2442440.0633873.0
 (SQL Overall)1786912441.156154577.0
 
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.