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

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

123 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
trammelling164261(None) 
tramelling1346371tra_melling
trammeling1544021tramme_ling
trameling1249052tra_me_ling
travelling1456532tra_velling
enamelling1344313ena_melling
gravelling1565213gra_velling
pommelling1743613_pommelling
pummelling1743163_pummelling
rappelling1544363_rappelling
ravelling13269243_ra_velling
tasselling1145233t_asselling
teaselling1145333tea_selling
teazelling2043803tea_zelling
trammelled1542223trammell_ed
tramming13279343tramm___ing
trampling1436973tra_m_pling
traveling1349053tra_ve_ling
trowelling1484913tr_owelling
barrelling1345454_barrelling
brailling1247774bra__illing
brambling1635544bra_m_bling
cancelling1547214_cancelling
chandelling1844454chandelling
channelling1743994channelling
compelling1746554_compelling
cramming15339434cramm___ing
crenelling1345684cr_enelling
dramming14347564dramm___ing
drivelling1543984dr_ivelling
enameling1246124ena_me_ling
farewelling1842624farewelling
flannelling1542834flannelling
fragmenting1843244fragmenting
gambolling1643444_gambolling
gavelling14286874_ga_velling
graveling1457384gra_ve_ling
grommeting1642914gromme_ting
grovelling1554164gr_ovelling
gruelling1155604gr__uelling
grummeting1642454grumme_ting
hammering1737634_hamme_ring
hanselling1445624_hanselling
impelling1436914__impelling
labelling1238084_la_belling
laurelling1144464_laurelling
mammering1337334_mamme_ring
marcelling1545594_marcelling
marvelling1645364_marvelling
melling102822624____melling
outsmelling1453564outsmelling
panelling1239074_pa_nelling
parallelling1571994parallelling
parcelling1546174_parcelling
pommeling1643874_pomme_ling
preselling1338694pr_eselling
pretelling1338134pr_etelling
propelling1556934pr_opelling
pummeling1643604_pumme_ling
quarrelling2143404quarrelling
rambling131810774_ra_m_bling
ramming123115064_ramm___ing
rappeling1435964_rappe_ling
raveling123414374_ra_ve_ling
ravellings14214454_ra_vellings
rebelling122111164_r_ebelling
refelling132211314_r_efelling
refuelling1474974_refuelling
remelting12311704_r_emelting
remodelling1542784_remodelling
repelling122312754_r_epelling
reselling102213834_r_eselling
resmelting1337264_resmelting
respelling1347974_respelling
retelling102112494_r_etelling
revelling132412554_r_evelling
rowelling1366994_r_owelling
smelling113712724___smelling
spancelling1643344spancelling
stammering1544524stamme_ring
steamrolling1551414steamrolling
tampering1438454t_ampe_ring
tasseling1035854t_asse_ling
teaseling1036914tea_se_ling
teazeling1934544tea_ze_ling
telling83321084t____elling
thralling13256834thra___lling
tinselling1145524t_inselling
towelling1366254t__owelling
trachling1537824tra__chling
trailering1145724traile_ring
trailing92916094tra___iling
trajecting2044294tra_jecting
tramell9398704tra_mell___
tramelled1266224tra_mell_ed
tramells10327834tra_mell__s
tramline10311384tra_m__line
trammel11357664tramme_l___
trammeled1453204tramme_l_ed
trammeler1343224tramme_l_er
trammelers1442514tramme_lers
trammels12295414tramme_l__s
tramping132711274tra_m__ping
trampoline1444534tra_mpoline
trampolining1751944trampolining
transecting1447374transecting
trapesing1247264tra_pe_sing
trapnesting1453154trapnesting
trauchling1643474tra_uchling
travailing1444614tra_vailing
traversing1444804tra_versing
trawling122710784tra___wling
trebling1139874tr___ebling
trembling1435194tr_em_bling
trilling92815964tr___illing
trimming13318654trimm___ing
trolling93212494tr___olling
troweling1376364tr_owe_ling
trumpeting1543574trumpe_ting
tunnelling1144384t_unnelling
unravelling1543154unra_velling
weaselling1454234wea_selling
yammering1735194_yamme_ring

Search took 10 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 Filter1786911488190.420425454.8
2DLD Change Limit1488191238.51617475.2
3Display Results1231230.0631952.4
 (SQL Overall)1786911238.99919856.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.