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

251 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
trampled1324790(None) 
trameled11309071trameled
tramped124312431tramp_ed
trample11299701trample_
trampler12278011trampler
tramples122610201tramples
brambled15316732brambled
cramped144712182cramp_ed
crimpled15366932crimpled
crumpled15296872crumpled
exampled2043352exampled
grappled14336092grappled
rambled123913522_rambled
ramped114617902_ramp_ed
rimpled123311422_rimpled
rumpled123810012_rumpled
sampled123410792_sampled
tamped114317042t_amp_ed
templed12278562t_empled
trachled1438312trachled
trailed83415672tra_iled
traipsed1134752traipsed
tramelled1266222tramelled
trammed123810712tram_med
trammeled1453202trammeled
tramper113812162tramp_er
trampier12318242trampier
tramplers13305882tramplers
trapped124512212tra_pped
traveled12349452traveled
trawled113411522tra_wled
trembled1335252trembled
tripled104113832tr_ipled
tromped124210292tromp_ed
trumped12439712trump_ed
ambled115116373__ambled
amped104820513__amp_ed
ample94720303__ample_
ampler104313303__ampler
brabbled12337633brabbled
brailed103914013bra_iled
brailled1147193brailled
bramble133710033bramble_
brambles14308973brambles
brattled11196723brattled
brawled133910123bra_wled
camped134720233_camp_ed
champed174111483champ_ed
clamped144012043clamp_ed
craaled10339423cra_aled
crackled17428863crackled
cradled113410813cra_dled
crammed143710123cram_med
crampier14288903crampier
crankled15408153crankled
craped116120533cra_p_ed
crapped143912633cra_pped
crawled133710403cra_wled
crimped143910763crimp_ed
crimple13408693crimple_
crimples14308963crimples
crippled15336803crippled
crumbled15357443crumbled
crumped144311223crump_ed
crumple13368363crumple_
crumples14348813crumples
damped124315583_damp_ed
dappled1336393_dappled
dimpled132810303_dimpled
drabbled14367053drabbled
draggled1254673draggled
drammed13378073dram_med
draped105314363dra_p_ed
drawled12368343dra_wled
drumbled14266033drumbled
enameled1136373enameled
example1844283example_
examples1944313examples
framed125116523fram__ed
frapped15318853fra_pped
frazzled20303993frazzled
gambled134112163_gambled
grabbled14327373grabbled
graphed1498473gra_phed
grapple12378003grapple_
grappler13336193grappler
grapples13348123grapples
grasped11409063grasp_ed
graveled13417363graveled
grumbled14256753grumbled
grumped13337333grump_ed
impled113812513__impled
kraaled12254983kra_aled
lamped114017543_lamp_ed
pimpled14289193_pimpled
prattled11246533prattled
preambled1643893preambled
primped14479153primp_ed
prompted1536903prompted
rabbled123514423_rabbled
raddled103812223_raddled
raffled14429083_raffled
railed74727543_ra_iled
ralphed1334363_ralphed
ramble104519973_ramble_
rambler113313263_rambler
rambles113118313_rambles
rammed113117303_ram_med
rampaged1434103_rampaged
rampole1139693_rampole_
rampoles1238893_rampoles
rankled123910653_rankled
raped85334623_ra_p_ed
rapped114122683_ra_pped
rappeled1335003_rappeled
rasped94715203_rasp_ed
rassled83310453_rassled
rattled84012953_rattled
raveled114113633_raveled
repled93319783_r_epled
resampled1454113resampled
rimple103814583_rimple_
rimples113114223_rimples
rippled123110273_rippled
romped114513653_romp_ed
rumbled124514593_rumbled
rumple103913013_rumple_
rumples113313133_rumples
sample104215013_sample_
sampler113212013_sampler
samples112815453_samples
scamped144711963scamp_ed
scrambled16164813scrambled
shambled16156153shambled
stamped124812813stamp_ed
stapled103613703sta_pled
straddled12205023straddled
straggled12296853straggled
strangled11268983strangled
strapped1357823stra_pped
swamped15498443swamp_ed
tabled94020043t_a_bled
tackled143913193t_ackled
tailed74424663t_a_iled
tamale83717403t_amale_
tamales93216153t_amales
tamed85528513t_am__ed
tamper104618513t_amp_er
tampered13279463t_ampered
tamponed1336023t_amponed
tangled94214643t_angled
taped85327423t_a_p_ed
tapped113820053t_a_pped
tattled84311483t_attled
teamed95418593team__ed
teaseled9186803teaseled
teazeled18194233teazeled
teazled17326833tea_zled
temped113912893t_emp_ed
temple102811333t_emple_
temples112610893t_emples
templet112712003t_emplet
tempted12317283t_empted
thralled1245803thra_lled
thumped15387413thump_ed
tippled12358393t_ippled
toppled12348843t_oppled
traced94821583tra__ced
trachle12311853trachle_
trachles13311753trachles
tracked143716133tra_cked
traded85717683tra__ded
traduced1244673traduced
traiked123310453tra_iked
trailer73015393tra_iler
trained84117203tra_ined
traipse935873traipse_
traipses1036873traipses
tramel84113713tram__el
tramell9398703tramel_l
tramells10327833tramells
tramels93812493tramel_s
tramless1037503tram_less
trammel11357663tram_mel
trammeler1343223trammeler
trammelled1542223trammelled
trammels12295413trammels
tramp96319773tramp___
trampers123210393trampers
trampiest13227903trampiest
tramping132711273tramping
trampish1535653trampish
trampling1436973trampling
tramps105114453tramp__s
trampy13499253tramp__y
tramroad1143763tramroad
tranced104414173tra_nced
trapes85024463tra_p_es
trapesed1136473trapesed
trapper113912803tra_pper
trashed113514703tra_shed
trauchled1543733trauchled
travailed1344223travailed
traveler11328433traveler
travelled1356863travelled
trawler104011903tra_wler
trawley13317303tra_wley
treadled1067123treadled
trebled1038483tr_ebled
treddled1134473treddled
tremble1138003tremble_
trembler1235363trembler
trembles1237353trembles
triangled1143943triangled
trickled152610433trickled
trifled113711963tr_ifled
trilled84116313tr_illed
trimmed12348933trim_med
trindled10388693trindled
triple84215923tr_iple_
triples94616873tr_iples
triplet94319213tr_iplet
triplex16447803tr_iplex
tripped123911693tr_ipped
triumphed1741943triumphed
trolled84312263tr_olled
trompe105611263tromp_e_
trompes114111623tromp_es
trooped104010723troop_ed
troubled1134983troubled
trouped103910983troup_ed
troweled12106113troweled
truckled15327313truckled
truffled1563993truffled
trumpet113810723trump_et
trumpeted1443053trumpeted
trundled10306393trundled
tumbled123412243t_umbled
tumped114216233t_ump_ed
twaddled14254623twaddled
twangled1364173twangled
twattled1273463twattled
unrumpled1443673unrumpled
unsampled1444443unsampled
vamped144211013_vamp_ed
wambled153610753_wambled
wimpled15338823_wimpled
wrangled1335593wrangled
wrapped15338023wra_pped
wrassled12325383wrassled
wrastled12346433wrastled

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622517.54619369.5
3Display Results2512510.0962614.6
 (SQL Overall)1786912518.07822120.7
 
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.