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

259 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
treadles93970(None) 
treacles1039701treacles
treadle8310101treadle_
treadled1067121treadled
treadler936861treadler
treadlers1045891treadlers
treadless1036001treadless
treddles1036261treddles
beadles103414732_beadles
breadless1235942breadless
cradles103114132cr_adles
readies83324712_readies
reales64934122_rea_les
reddles93315772_reddles
teazles16308922t_eazles
threadless1442472threadless
trades75724502tr_ad_es
treacle939972treacle_
treaded95014282tread_ed
treader84113832tread_er
treaders93311842treaders
treads74817922tread__s
treaties8316982treaties
trebles9311442tre_bles
treddle936432treddle_
treddled1134472treddled
trembles1237352trembles
trendies9312212trendies
trestles83012552trestles
trindles93211682trindles
trundles9278482trundles
tweedles1234112tweedles
arables91814973ar_ables
arcades101113193arcad_es
areoles71016953are_oles
beadle93314683_beadle_
beagles103212123_beagles
breaches153714123breaches
breaded115014063bread_ed
breadlines1345733breadlines
breads95419203bread__s
breadths1474463breadths
breathes134212903breathes
bredes94818473bre_d_es
bridles104114473br_idles
brindles113710223brindles
cradle93313163cr_adle_
cradled113410813cr_adled
cradler102910513cr_adler
cradlers11309203cr_adlers
creases94020963crea_ses
creates95225193crea_tes
creoles9913323cre_oles
crevalles1455723crevalles
dreaded103612023dread_ed
dreads84115023dread__s
dreamless1243513dreamless
drearies92313413drearies
dredges10379343dre_dges
dreidels1033213dreidels
dreidls934053dreidl_s
dryades12395633dryad_es
eagles73819163__eagles
freckles17126383freckles
grades84926313gr_ad_es
greases84816713grea_ses
greaves113311443grea_ves
greedless1144893greedless
grenades1038433grenad_es
griddles1145753griddles
headless12289863_headless
heddles123311623_heddles
irades74517393ir_ad_es
kleagles1343143kleagles
ladles74619543__ladles
leadless9248793_leadless
measles92412753_measles
meddles113213253_meddles
needles83211563_needles
oracles93212423or_acles
oreads73915773oread__s
oreides8312023oreid_es
padles95221123__padles
peddles112913703_peddles
preaches153214893preaches
preadults1244283preadults
preambles1545333preambles
predates11615813predates
prefades1439533prefad_es
prefiles133113443prefiles
prehandles1644183prehandles
presales10315263presales
raddles93615703_raddles
rales54947493_r_a_les
reaches123423203_reaches
readded103310733_readded
readds84111643_read_ds
reader73628293_read_er
readers83823773_readers
readied93316623_readied
readier83117423_readier
readiest93719043_readiest
reads64835273_read__s
realer63528593_rea_ler
realest73322433_rea_lest
realms84913493_rea_lms
reals55038653_rea_l_s
reaves94127573_rea_ves
redates83423873_redates
reddle83815913_reddle_
reddled102912323_reddled
redes65139123_re_d_es
redleg839263_re_dleg
redlegs936823_re_dlegs
redoes74623753_re_does
redyes104214083_re_dyes
refiles104122423_refiles
regales83520793_regales
rehandles1345593_rehandles
resaddles11114693_resaddles
resales74724903_resales
resiles74026543_resiles
resoles73823653_resoles
retables101712673_retables
retiles74426993_retiles
reviles104421353_reviles
riddles93215023_riddles
roadies83317443_roadies
roadless937703_roadless
ruddles92813873_ruddles
rundles83214713_rundles
steadies9311123steadies
straddles11216403straddles
streamlet1146043streamlet
streamlets1243073streamlets
tables84524883t__ables
tales55451373t__a_les
tamales93216153tama_les
taxables1734383taxables
teaches122718353t_eaches
teals56234133t_ea_l_s
tearless848713t_earless
teasels74311313t_easels
teases65426273t_ea_ses
teazels16406893t_eazels
teazle15329553t_eazle_
teazled17326833t_eazled
teddies92711283t_eddies
teles54536003t_e__les
temples112610893t_emples
theatres11298633theatres
threaded1366323thread_ed
threader1256733thread_er
threaders1365743threaders
threadier1354473threadier
threadiest1444283threadiest
threads11419953thread__s
tirades8311723tirad_es
toadies82914863t_oadies
toadless936313t_oadless
toddles93211533t_oddles
toreadors1045143toreadors
tornadoes1044293tornadoes
torsades937213torsad_es
traces85329933tr_a_ces
trachles13311753trachles
trade65026043tr_ad_e_
traded85717683tr_ad_ed
trader75218763tr_ad_er
traders84316953tr_aders
traduces1136563tr_aduces
trailed83415673tr_ailed
trailer73015393tr_ailer
trailers82912923tr_ailers
trails64622513tr_ail_s
tramels93812493tr_amels
tramless1037503tr_amless
tramples122610203tramples
trances93919643tr_ances
trapes85024463tr_a_pes
trashes104119263tr_ashes
trasses74819323tr_asses
travels104711293tr_avels
traves94222743tr_a_ves
trawled113411523tr_awled
trawler104011903tr_awler
trawlers113310203tr_awlers
trawley13317303tr_awley
trawleys14284383tr_awleys
trawls94412393tr_awl_s
treaclier1144153treaclier
treacliest1245383treacliest
treacly1237093treacl_y
tread64821703tread___
treading103515333treading
treadling1137503treadling
treadmills1351953treadmills
treasons848683treasons
treasures946633treasures
treated83618703trea_ted
treater74219833trea_ter
treaters83615843treaters
treatise8311103treatise
treatises9310373treatises
treats64821693trea__ts
treble8311663tre_ble_
trebled1038483tre_bled
treeless839283tre_eless
trees55835763tre___es
trehalas1144883trehalas
trellis739873tre_llis
tremble1138003tremble_
trembled1335253trembled
trembler1235363trembler
tremblers1334483tremblers
tremolos1046043tremolos
trenails869843trenail_s
trenches133512603trenches
trended94011763trend_ed
trendier937913trendier
trendiest1038423trendiest
trends75513543trend__s
tressels8367653tressels
tresses73719543tre_sses
trestle72611363trestle_
trevallies1343463trevallies
trevallys1542213trevallys
triable92515393triable_
triadics1146133triadics
triads74513533triad__s
triages82613793tria_ges
trials64319883tria_l_s
triangles1035743triangles
triazoles1844393triazoles
tribades1136893tribad_es
trickles143013763trickles
trifles103814823tr_ifles
trindle83311363trindle_
trindled10388693trindled
triodes84012503triod_es
triples94616873tr_iples
troubles1057203troubles
truckles14319383truckles
trudges9339993tr_udges
truffles1485593truffles
trundle8307873trundle_
trundled10306393trundled
trundler9256153trundler
trundlers10215003trundlers
tsades74310993t_sad_es
twaddles13315723twaddles
tweedle1134193tweedle_
tweedled1332833tweedled
twiddles13265613twiddles
ureases74416723urea_ses
ureides8311103ureid_es
wheedles1534643wheedles
wreathes14299893wreathes
wrestles113310063wrestles

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.1561145455.1
2DLD Change Limit1461622598.40617387.8
3Display Results2592590.1102354.5
 (SQL Overall)1786912598.67220605.5
 
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.