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

196 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
trampling143697(None) 
trameling1249051trameling
tramping132711271tramp_ing
brambling1635542brambling
cramping153411852cramp_ing
crimpling1645342crimpling
crumpling1645322crumpling
exampling2143552exampling
grappling1544992grappling
rambling131810772_rambling
ramping123316872_ramp_ing
rimpling13219662_rimpling
rumpling13178762_rumpling
sampling13510642_sampling
tamping122815812t_amp_ing
trachling1537822trachling
trailing92916092tra_iling
traipsing1235072traipsing
tramelling1346372tramelling
tramline10311382tram_line
trammeling1544022trammeling
tramming13279342tram_ming
trampoline1444532trampoline
trapline10411862tra_pline
trapping132911392tra_pping
traveling1349052traveling
trawling122710782tra_wling
trembling1435192trembling
tripling112712552tr_ipling
tromping13319602tromp_ing
trumping13308732trump_ing
ambling121411793__ambling
amping114317573__amp_ing
brabbling1334963brabbling
brailing113514793bra_iling
brailling1247773brailling
bramblings1742613bramblings
brandling1348253brandling
brattling1236003brattling
brawling143210043bra_wling
camping143118973_camp_ing
champing183610933champ_ing
clamping154011153clamp_ing
craaling112711353cra_aling
crackling18157003crackling
cradling122411453cra_dling
cramming15339433cram_ming
crankling16147293crankling
craping124018713cra_p_ing
crapping153911453cra_pping
crawling143110513cra_wling
crimping15299783crimp_ing
crippling1644093crippling
crumbling1655083crumbling
crumping15319903crump_ing
damping133414003_damp_ing
dappling1436843_dappling
dimpling14199023_dimpling
drabbling1544553drabbling
draggling1354613draggling
dramming14347573dram_ming
draping114213353dra_p_ing
drawling13318673dra_wling
drumbling1544033drumbling
dumpling14217893_dumpling
enameling1246123enameling
framing133014793fram__ing
frapping16348103fra_pping
frazzling2143153frazzling
gambling14218963_gambling
grabbling1564583grabbling
graphing1538533gra_phing
graplin1058443gra_plin_
grapline1138723gra_pline
graplins1148263gra_plins
grapplings1642323grapplings
grasping12348833grasp_ing
graveling1457383graveling
grayling1338003gra_yling
grumbling1544083grumbling
grumping14266903grump_ing
kraaling13186663kra_aling
lamping123116003_lamp_ing
prattling1246303prattling
primping15338893primp_ing
prompting1637203prompting
rabbling13239333_rabbling
raddling11229773_raddling
raffling1567063_raffling
railing83325643_ra_iling
ralphing1435413_ralphing
ramming123115063_ram_ming
rampaging1544513_rampaging
rankling132610113_rankling
raping94829853_ra_p_ing
rappeling1435963_rappeling
rapping123619103_ra_pping
rasping104316253_rasp_ing
rassling939013_rassling
rattling92510873_rattling
raveling123414373_raveling
resampling1544333resampling
rippling13197573_rippling
romping123113033_romp_ing
rumbling131910103_rumbling
samplings1435553_samplings
sapling103217863_sa_pling
scamping153510193scamp_ing
scrambling1743473scrambling
shambling1735593shambling
stamping133310963stamp_ing
stapling112813153sta_pling
straddling1343643straddling
straggling1344303straggling
strangling1256403strangling
strapping1436993stra_pping
stripling1257783str_ipling
swamping16307923swamp_ing
tabling103216033t_a_bling
tackling153211123t_ackling
tailing82923103t_a_iling
taming94023433t_am__ing
tampering1438453t_ampering
tamponing1445993t_amponing
tangling101712543t_angling
taping94222393t_a_p_ing
tapping123317133t_a_pping
tattling9259473t_attling
teaming103917593team__ing
teaseling1036913teaseling
teazeling1934543teazeling
teazling1856573tea_zling
temping122710693t_emp_ing
tempting1357343t_empting
thralling13256833thra_lling
thumping16296713thump_ing
tippling13196703t_ippling
toppling13197353t_oppling
tracing103720153tra__cing
tracking153715463tra_cking
trading93517973tra__ding
traducing1374013traducing
traiking132511973tra_iking
training93015863tra_ining
tramlines1139843tram_lines
trammelling1642613trammelling
trampier12318243tramp_ier
trampish1535653tramp_ish
trample11299703trampl__e
trampled13247903trampl_ed
trampler12278013trampl_er
tramplers13305883tramplers
tramples122610203trampl_es
trampoliner1552313trampoliner
trampolines1543903trampolines
trampolining1751943trampolining
trancing112812023tra_ncing
trapesing1247263trapesing
traplike1437653tra_plike
traplines11310373tra_plines
trappings14265753tra_ppings
trashing122613223tra_shing
trauchling1643473trauchling
travailing1444613travailing
travelling1456533travelling
treadling1137503treadling
trebling1139873tr_ebling
treddling1234423treddling
trickling1647723trickling
trifling122411503tr_ifling
trilling92815963tr_illing
trimming13318653trim_ming
trindling1137133trindling
tripping133210923tr_ipping
triumphing1842243triumphing
trolling93212493tr_olling
trooping112710283troop_ing
troubling1234943troubling
trouping11249503troup_ing
troweling1376363troweling
truckling1645073truckling
trumpeting1543573trumpeting
trundling1135003trundling
tumbling13219293t_umbling
tumping123114243t_ump_ing
tumpline1237113t_umpline
twaddling1552713twaddling
twangling1434453twangling
twattling1332693twattling
vamping152810233_vamp_ing
wambling16198443_wambling
wimpling16207483_wimpling
wrangling1456223wrangling
wrapping16297623wra_pping
wrassling1334273wrassling
wrastling1335523wrastling

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411967.64319448.0
3Display Results1961960.0762578.9
 (SQL Overall)1786911968.15521911.8
 
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.