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 “trample” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

291 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
trample1129970(None) 
trampled13247901trampled
trampler12278011trampler
tramples122610201tramples
ample94720302__ample
bramble133710032bramble
crimple13408692crimple
crumple13368362crumple
example1844282example
grapple12378002grapple
ramble104519972_ramble
rampole1139692_rampole
rimple103814582_rimple
rumple103913012_rumple
sample104215012_sample
tamale83717402t_amale
temple102811332t_emple
trachle12311852trachle
traipse935872traipse
tramel84113712tramel_
trameled11309072trameled
tramell9398702tramell
tramels93812492tramels
trammel11357662trammel
tramp96319772tramp__
tramped124312432tramped
tramper113812162tramper
trampier12318242trampier
tramplers13305882tramplers
tramps105114452tramp_s
trampy13499252tramp_y
tremble1138002tremble
triple84215922tr_iple
trompe105611262tromp_e
amble95924643__amble
amole75724593__amole
ampler104313303__ampler
amply125012913__amply
ampule10710613__ampule
apple94517673__apple
arable81821003ara_ble
arame75026623aram__e
atremble1244113atremble
brabble10349973brabble
braille939713braille
brambled15316733brambled
brambles14308973brambles
brambly16296253brambly
brattle9249253brattle
crackle153611253crackle
cradle93313163cra_dle
crambe1239073cram_be
cramp115120693cramp__
cramped144712183cramped
crampier14288903crampier
crampit1338863crampit
crampon1336943crampon
cramps125615563cramp_s
crampy154710993cramp_y
crankle133610063crankle
crape96128443cra_p_e
crappie13298983crappie
crimpled15366933crimpled
crimples14308963crimples
cripple13378583cripple
crumble133410403crumble
crumpled15296873crumpled
crumples14348813crumples
crumply16336093crumply
damply14337893_damply
dapple1138853_dapple
dimple113512793_dimple
drabble12238883drabble
draggle1056103draggle
drape85319633dra_p_e
drumble12337893drumble
ensample1242983ensample
exampled2043353exampled
examples1944313examples
fragile1147843fragile
framable1537573framable
frame105821803fram__e
frappe13286953fra_ppe
frazzle18305223frazzle
gamble115417183_gamble
grabble12339643grabble
gracile102512603gracile
grackle14338893grackle
gramme114210333gram_me
gramp106218323gramp__
grampa115010173gramp_a
grampas12399253grampas
gramps114114273gramp_s
grampus12356313grampus
granule839473granule
grape84824663gra_p_e
grappled14336093grappled
grappler13336193grappler
grapples13348123grapples
graupel1034133graupel
gripple12416613gripple
grumble12349233grumble
maple95521143_ma_ple
oracle84313293ora_cle
pimple123512963_pimple
prattle9208833prattle
preamble1436383preamble
rabble103818243_rabble
rackle123917293_rackle
raddle84816173_raddle
raffle123910703_raffle
raggle83712883_raggle
rale45050563_ra__le
ramal74622243_ramal_
ramate83921683_ramate
rambla103510933_rambla
rambled123913523_rambled
rambler113313263_rambler
rambles113118313_rambles
ramee74633853_ram_ee
ramie75027823_ram_ie
ramilie9310283_ramilie
ramose8314403_ramose
ramp85934003_ramp__
rampage1237453_rampage
ramped114617903_ramped
rampike1536603_rampike
rampoles1238893_rampoles
ramps96224633_ramp_s
rankle103414883_rankle
rape65041633_ra_p_e
raphe104916423_ra_phe
rappee103618673_rappee
rappel104211953_rappel
rassle63813203_rassle
rattle64717613_rattle
resample1244673resample
rimpled123311423_rimpled
rimples113114223_rimples
ripple103413913_ripple
rumble103718813_rumble
rumpled123810013_rumpled
rumples113313133_rumples
rumply13348573_rumply
sampled123410793_sampled
sampler113212013_sampler
samples112815453_samples
scramble14177253scramble
scrapple1434683scrapple
semple103212753_semple
shamble14149263shamble
simple104315173_simple
staple84415823sta_ple
straddle10186223straddle
straggle10359133straggle
strangle98411503strangle
table75429603t_a_ble
tackle123815733t_ackle
tadpole1036143t_adpole
taille63116923t_aille
tale46154163t_a__le
tamable11312853t_amable
tamal73522623t_amal_
tamales93216153t_amales
tamals84116633t_amals
tame66343663t_am__e
tamely113711953t_amely
tammie104212693t_ammie
tamp86133003t_amp__
tampala1136613t_ampala
tampan102512323t_ampan
tamped114317043t_amped
tamper104618513t_amper
tampon102911233t_ampon
tamps95524083t_amp_s
tangle74019953t_angle
tape64538143t_a_p_e
tattle64115653t_attle
taupe7314163t_aup_e
tawpie11339143t_awpie
teazle15329553tea_zle
templed12278553t_empled
temples112610893t_emples
templet112712003t_emplet
thimble1435873thimble
tipple103411913t_ipple
topple104411323t_opple
trace75829613tra__ce
trachled1438313trachled
trachles13311753trachles
tractile10311073tractile
tradable1139873tradable
trade65026043tra__de
traduce1036353traduce
trail55126773tra_il_
trailed83415673tra_iled
trailer73015393tra_iler
trails64622513tra_ils
trainee72817793trainee
traipsed1134753traipsed
traipses1036873traipses
tram67034553tram___
tramcar1135593tramcar
tramelled1266223tramelled
tramells10327833tramells
tramless1037503tram_less
tramline10311383tramline
trammed123810713trammed
trammeled1453203trammeled
trammeler1343223trammeler
trammels12295413trammels
trampers123210393trampers
trampiest13227893trampiest
tramping132711273tramping
trampish1535653trampish
trampling1436963trampling
trampoline1444523trampoline
trams75327673tram__s
tramway1544863tramway
trance84718763tra_nce
tranche123312223tranche
trap67532803tra_p__
trapan82412973tra_pan
trapes85024463tra_pes
trapeze1836253trapeze
traplike1437653tra_plike
trapline10411863tra_pline
trapped124512213trapped
trapper113912803trapper
trappose1245813trappose
traps75727483tra_p_s
trapt76433393tra_p_t
trauchle1344963trauchle
trave85223033tra__ve
travel94112983travel_
traveled12349453traveled
traveler11328433traveler
travels104711293travels
trawl84915873tra_wl_
trawled113411523tra_wled
trawler104011903tra_wler
trawley13317303tra_wley
trawls94412393tra_wls
treacle939973treacle
treadle8310103treadle
treble8311663tr_eble
treddle936433treddle
trembled1335253trembled
trembler1235363trembler
trembles1237353trembles
trembly1435523trembly
tremolo946513tremolo
trestle72611363trestle
triable92515393triable
triangle935533triangle
triazole1744153triazole
trickle133613443trickle
trifle94012883tr_ifle
trimly114410893trim_ly
trindle83311363trindle
tripe75425383tr_ip_e
tripled104113833tr_ipled
triples94616873tr_iples
triplet94319213tr_iplet
triplex16447803tr_iplex
triply114211023tr_iply
trommel11315363trommel
tromp95815803tromp__
tromped124210293tromped
trompes114111623trompes
tromps104911703tromp_s
trope75725803tr_op_e
trouble957713trouble
troupe84812433troup_e
truckle13358863truckle
truffle1384893truffle
trump95615123trump__
trumped12439713trumped
trumpet113810723trumpet
trumps104611883trump_s
trundle8307873trundle
tumble103215643t_umble
twaddle12245713twaddle
twangle1145803twangle
twattle1064273twattle
tyramine1347303tyramine
wamble134415753_wamble
wimple133611363_wimple
wrangle1137383wrangle
wrassle10357173wrassle
wrastle10368993wrastle

Search took 9 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 Filter1786911340270.186960704.3
2DLD Change Limit1340272917.65617506.1
3Display Results2912910.296983.1
 (SQL Overall)1786912918.13821957.6
 
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.