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

249 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
treadled106712(None) 
treaded95014281tread_ed
treadle8310101treadle_
treadler936861treadler
treadles939701treadles
treddled1134471treddled
breaded115014062bread_ed
cradled113410812cr_adled
dreaded103612022dread_ed
readded103310732_readded
readied93316622_readied
reddled102912322_reddled
teazled17326832t_eazled
threaded1366322thread_ed
traded85717682tr_ad_ed
trailed83415672tr_ailed
trawled113411522tr_awled
treacle939972treacle_
treacles1039702treacles
treader84113832tread_er
treadlers1045892treadlers
treadless1036002treadless
treated83618702trea_ted
trebled1038482tre_bled
treddle936432treddle_
treddles1036262treddles
trembled1335252trembled
trended94011762trend_ed
trindled10388692trindled
trundled10306392trundled
tweedled1332832tweedled
arcaded1178973arcad_ed
beaded104922423_bead_ed
beadle93314683_beadle_
beadles103414733_beadles
bradded12388713br_added
brailed103914013br_ailed
brawled133910123br_awled
breached163411643breached
breadless1235943breadless
breamed124011593brea_med
breasted1138823breasted
breathed14469643breathed
bridled113611143br_idled
brindled12407853brindled
craaled10339423cr_aaled
cradle93313163cr_adle_
cradler102910513cr_adler
cradles103114133cr_adles
crawled133710403cr_awled
creaked143413233crea_ked
creamed123913713crea_med
creased104315583crea_sed
created104323453crea_ted
creeled104012013cre_eled
creneled11326893creneled
derailed102410403derailed
drawled12368343dr_awled
dreamed114310633drea_med
dredged11346893dre_dged
eagled82914043__eagled
freaked15399703frea_ked
freckled18104443freckled
graded94919553gr_ad_ed
greased93812393grea_sed
greaved12408913grea_ved
griddled1244203griddled
headed114020473_head_ed
healed105121443_hea_led
heralded1335443heralded
kneaded13146473knead_ed
kraaled12254983kr_aaled
ladled85013483__ladled
leaded84221543_lead_ed
measled10339303_measled
medaled113411613_medaled
meddled123210033_meddled
needled9358513_needled
pealed95322813_pea_led
pearled10411553_pearled
pedaled113711893_pedaled
peddled123410543_peddled
pleaded113511263plead_ed
preached163412063preached
preacted132710943preacted
preaged11612333prea_ged
preambled1643893preambled
prearmed1397993prearmed
predated12513273predated
prefaded1537823prefad_ed
prefiled143310573prefiled
prehandled1743633prehandled
prevailed1536043prevailed
radded94716493_r_added
raddled103812223_raddled
railed74727543_r_ailed
reached134619083_reached
reacted103015713_reacted
readd74617133_read__d
reader73628293_read_er
readier83117423_readier
readies83324713_readies
realer63528593_rea_ler
reales64934123_rea_les
reamed94326123_rea_med
reaped94122453_rea_ped
reared75930013_rea_red
rearmed103912823_rearmed
reaved104523923_rea_ved
recalled11310803_recalled
redated93120923_redated
redded94019553_re_dded
reddle83815913_reddle_
reddles93315773_reddles
reded74829123_re_d_ed
redleg839273_re_dleg
redyed114611243_re_dyed
reeded84022563_reed_ed
reeled74725533_re_eled
refiled114318653_refiled
regaled93615963_regaled
rehandled1444763_rehandled
remailed112411403_remailed
renailed92512803_renailed
rended84524103_rend_ed
reoiled84316853_reoiled
repled93319783_re_pled
resaddled1294253_resaddled
resailed93613063_resailed
resiled84621983_resiled
resoled84119283_resoled
retailed94113963_retailed
retiled84420513_retiled
retreaded1137053retread_ed
reveled113917753_reveled
reviled114417923_reviled
riddled103012043_riddled
roadbed1134793_roadbed
ruddled103010873_ruddled
sealed74328363_sea_led
steaded92811673stead_ed
steadied1036563steadied
straddled12205023straddled
streaked13228453strea_ked
streambed1483333streambed
streamed11258903strea_med
streamlet1146043streamlet
streeled9267863stre_eled
tabled94020043t__abled
tailed74424663t__ailed
teamed95418593t_ea_med
teared75722153t_ea_red
teased74721153t_ea_sed
teaseled9186793t_easeled
teated74924023t_ea_ted
teazeled18194233t_eazeled
teazle15329553t_eazle_
teazles16308923t_eazles
tedded93810903t_e_dded
templed12278563t_empled
tended83819483t_end_ed
thralled1245803thralled
threader1256733thread_er
threadier1354473threadier
threadless1442473threadless
threaped1454863threa_ped
threated1259203threa_ted
toadied9248013t_oadied
toddled10328823t_oddled
toenailed1043483toenailed
totaled839693tota_led
totalled935843totalled
traced94821583tr_a_ced
trachled1438313trachled
tracked143716133tr_acked
trade65026043tr_ad_e_
trader75218763tr_ad_er
trades75724503tr_ad_es
traduced1244673tr_aduced
traiked123310453tr_aiked
trailer73015393tr_ailer
trained84117203tr_ained
trameled11309073trameled
trammed123810713tr_ammed
tramped124312433tr_amped
trampled13247903trampled
tranced104414173tr_anced
trapped124512213tr_apped
trashed113514703tr_ashed
travailed1344223travailed
traveled12349453traveled
trawler104011903tr_awler
trawley13317303tr_awley
treaclier1144153treaclier
treacly1237093treacl_y
tread64821703trea___d
treaders93311843treaders
treading103515333treading
treadling1137503treadling
treads74817923tread__s
treasured1044983treasured
treater74219833trea_ter
treaties8316983treaties
treble8311663tre_ble_
trebles9311443tre_bles
treed65626733tre___ed
trekked1134343tre_kked
tremble1138003tremble_
trembler1235363trembler
trembles1237353trembles
trenched14289853trenched
trendier937913trendier
trendies9312213trendies
trendoid1045453trendoid
trepanned1243913trepanned
tressed83714263tre_ssed
trestle72611363trestle_
trestles83012553trestles
triable92515393triable_
triaged92810443tria_ged
triangled1143943triangled
trickled152610433trickled
trifled113711963tr_ifled
trilled84116313tr_illed
trindle83311363trindle_
trindles93211683trindles
tripled104113833tr_ipled
troaked12438253troa_ked
trolled84312263tr_olled
troubled1134983troubled
troweled12106113troweled
truanted935373truanted
truckled15327313truckled
trudged10298043tr_udged
truffled1563993truffled
trundle8307873trundle_
trundler9256153trundler
trundles9278483trundles
twaddled14254623twaddled
tweaked1534403twea_ked
tweedle1134193tweedle_
tweedles1234113tweedles
twiddled14284633twiddled
untreaded1137983untread_ed
vealed103916323_vea_led
wheedled1633033wheedled
wreaked15369023wrea_ked
wreathed15257463wreathed
wrestled12296763wrestled

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.423422437.4
2DLD Change Limit1461622497.46619577.0
3Display Results2492490.0962593.8
 (SQL Overall)1786912497.98522378.3
 
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.