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

168 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
treadlers104589(None) 
treaders93311841tread_ers
treadler936861treadler_
treadles939701treadle_s
treadless1036001treadless
breadless1235942breadless
cradlers11309202cr_adlers
readers83823772_read_ers
threaders1365742thread_ers
threadless1442472threadless
traders84316952tr_ad_ers
trailers82912922tr_ailers
trawlers113310202tr_awlers
treacles1039702treacle_s
treader84113832tread_er_
treadle8310102treadle__
treadled1067122treadle_d
treaters83615842trea_ters
treddles1036262treddle_s
tremblers1334482tremblers
trundlers10215002trundlers
beaders104120183_bead_ers
beadles103414733_beadle_s
brawlers13408643br_awlers
breachers16369853breachers
breakers143810973brea_kers
breathers14319103breathers
breeders11368893breed_ers
bridlers11359183br_idlers
cradler102910513cr_adler_
cradles103114133cr_adle_s
crawlers13309013cr_awlers
creamers124111313crea_mers
creasers103612843crea_sers
dealers84118613_dea_lers
drawlers12307313dr_awlers
dreamers11369003drea_mers
dreamless1243513dreamless
dredgers11256093dre_dgers
graders94716013gr_ad_ers
greasers93410253grea_sers
greedless1144893greedless
grenadiers1242593grenadiers
headers113819393_head_ers
headless12289863_headless
healers104319463_hea_lers
kneaders1384713knead_ers
ladlers84613573__ladlers
leaders83819603_lead_ers
leadless9248793_leadless
meddlers12318203_meddlers
needlers9287423_needlers
pearlers1039033_pearlers
pedalers11239393_pedalers
peddlers12298533_peddlers
pedlers103013273_pe_dlers
pleaders113210183plead_ers
preachers16339573preachers
prealters1147773prealters
preavers13910263prea_vers
prevailers15123833prevailers
railers74420663_r_ailers
reachers133515723_reachers
reader73628293_read_er_
readier83117423_readier_
readies83324713_readie_s
realer63528593_rea_ler_
reales64934123_rea_le_s
realters83614043_realters
reamers94221083_rea_mers
reapers93520453_rea_pers
rearers74323563_rea_rers
reavers108320743_rea_vers
recallers1137103_recallers
redders93615343_re_dders
reddles93315773_reddle_s
redlegs936823_re_dlegs
reelers73520273_re_elers
regalers94311133_regalers
renders83821673_rend_ers
retailers9258773_retailers
revelers113414133_revelers
revilers114011693_revilers
riddlers10269103_riddlers
roadless937703_roadless
sealers74323553_sea_lers
spreaders1236503spread_ers
steadiers1035083steadiers
stealers83412213stea_lers
straddlers12203823straddlers
streakers13218133strea_kers
streamers11228073strea_mers
streamlets1243073streamlets
tailers73720183t__ailers
talers64628143t__a_lers
teachers133212393t_eachers
tearers75218233t_ea_rers
tearless848713t_earless
teaselers9165853t_easelers
teasers75317243t_ea_sers
teazles16308923t_eazle_s
tedders94010233t_e_dders
tellers73717603t_e_llers
tenders83719723t_end_ers
thalers106212263t_ha_lers
theaters114211903thea_ters
threader1256733thread_er_
threadier1354473threadier_
threapers1444773threa_pers
tiddlers10288653t_iddlers
toadless936313t_oadless
toddlers10346963t_oddlers
toreadors1045153toread_ors
tracers94917843tr_a_cers
trackers143512853tr_ackers
trader75218763tr_ad_er_
trades75724503tr_ad_e_s
traducers1243723tr_aducers
trailer73015393tr_ailer_
trainers83114643tr_ainers
tramless1037503tr_amless
trampers123210393tr_ampers
tramplers13305883tramplers
trappers123711043tr_appers
trashers113013643tr_ashers
travelers12266773travelers
trawler104011903tr_awler_
trawleys14284383tr_awleys
treachery1744693treachery
treacle939973treacle__
treaclier1144153treaclier_
treaded95014283tread_e_d
treadling1137503treadling
treads74817923tread___s
treasurers1043203treasurers
treasures946633treasures
treater74219833trea_ter_
treaties8316983treatie_s
trebles9311443tre_ble_s
treddle936433treddle__
treddled1134473treddle_d
treeless839283tre_eless
trekkers1133803tre_kkers
trembler1235363trembler_
trembles1237353tremble_s
trenchers14288073trenchers
trendier937913trendier_
trendies9312213trendie_s
trepanners1243083trepanners
trestles83012553trestle_s
triflers113110213tr_iflers
trillers83613493tr_illers
trindles93211683trindle_s
trollers83211213tr_ollers
troublers1135003troublers
trowelers12105263trowelers
trucklers15295583trucklers
trudgers10256863tr_udgers
trundler9256153trundler_
trundles9278483trundle_s
twaddlers14343613twaddlers
tweedles1234113tweedle_s
twiddlers14313693twiddlers
vealers103214293_vea_lers
wheedlers1643193wheedlers
wreakers15328423wrea_kers
wreathers15257493wreathers
wrestlers12306103wrestlers

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.406440125.6
2DLD Change Limit1486411687.87618872.7
3Display Results1681680.0632666.7
 (SQL Overall)1786911688.34521412.9
 
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.