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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
tramelled126622(None) 
trameled11309071trame_led
trammelled1542221trammelled
travelled1356861travelled
enamelled1244622enamelled
gravelled1475552gravelled
ravelled12419782_ravelled
teaselled1045152teaselled
teazelled1943742teazelled
tramell9398702tramell__
tramells10327832tramell_s
trammeled1453202trammeled
trampled13247902tram_pled
traveled12349452trave_led
traveller1266602traveller
trowelled1344442trowelled
barrelled1245263barrelled
brailled1147193bra_illed
brambled15316733bram_bled
crenelled1245403crenelled
drivelled1443983drivelled
enameled1136373ename_led
enameller1144173enameller
gabelled12317583_gabelled
gavelled13387363_gavelled
graveled13417363grave_led
grovelled1454183grovelled
gruelled1034893gr_uelled
labelled11278293_labelled
lapelled11227083_lapelled
marcelled1445203marcelled
marvelled1544963marvelled
melled95023023___melled
panelled1138963_panelled
parcelled1445783parcelled
pommelled1643083pommelled
propelled1456913propelled
pummelled1643073pummelled
rambled123913523_ram_bled
rappelled1443703_rappelled
raveled114113633_rave_led
raveller11339263_raveller
rebelled113110333_rebelled
refelled122810173_refelled
remelted11310153_remelted
repelled113111593_repelled
revelled123712743_revelled
rowelled1236633_rowelled
smelled103511863__smelled
tasselled1044663tasselled
teaseled9186803tease_led
teaseller945223teaseller
teazeled18194233teaze_led
thralled1245803thra__lled
tinselled1044423tinselled
towelled1236353t_owelled
trabeated1246843trabeated
traceried1247143traceried
trachled1438313tra_chled
trailed83415673tra__iled
trailered1045393trailered
trajected1944043trajected
tramel84113713trame_l__
trameling1249053trameling
tramelling1346373tramelling
tramels93812493trame_l_s
trammed123810713tram__med
trammeler1343223trammeler
tramped124312433tram__ped
trample11299703tram_ple_
trampler12278013tram_pler
tramples122610203tram_ples
trapesed1136473trape_sed
trauchled1543733trauchled
travailed1344223travailed
traveler11328433trave_ler
travellers1364663travellers
traversed1344563traversed
trawled113411523tra__wled
trebled1038483tr__ebled
trembled1335253trem_bled
trilled84116313tr__illed
trolled84312263tr__olled
troweled12106113trowe_led
troweller1244563troweller
tunnelled1054583tunnelled
unravelled1443863unravelled
weaselled1344213weaselled

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.423422437.4
2DLD Change Limit148641887.75019179.5
3Display Results88880.0302933.3
 (SQL Overall)178691888.20321783.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.