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

117 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
threeped145437(None) 
threaped1454861threaped
cheeped153410592ch_eeped
creeped12329712_creeped
threaded1366322threaded
threaper1345142threaper
threated1259202threated
threep115910112threep__
threeps12687042threep_s
threshed1535642threshed
wheeped16387502wh_eeped
beeped115313453__beeped
bleeped12287273_bleeped
breezed19287053_breezed
careened1139193careened
careered1139493careered
cheeked17399663ch_eeked
cheeper143610743ch_eeper
cheered133713293ch_eered
cheesed133910683ch_eesed
creeled104012013_creeled
creeper11339973_creeper
creped114115703_cr_eped
greened93111263_greened
greeted93111383_greeted
heaped124516903_h_eaped
heeded114215763_h_eeded
heeled104018413_h_eeled
heezed194210513_h_eezed
helped124714153_h_elped
jeeped16469843__jeeped
peeped113915383__peeped
phreaked1834493phreaked
preened103214983_preened
prepped11329893_prepped
reaped94122453__reaped
reeded84022563__reeded
reefed103816583__reefed
reeked113717643__reeked
reeled74725533__reeled
reeved104118713__reeved
repped114616723__repped
screeded1235633screeded
screened1137403screened
seeped94317523__seeped
sheened113511703sh_eened
sheered113515453sh_eered
sheeted113813043sh_eeted
shlepped1633643shlepped
shredded1444063shredded
shrewed14589843shr_ewed
shrieked16265173shrieked
shrieved15276073shrieved
shrimped1634213shrimped
steeped103412283_steeped
streeked13246153streeked
streeled9267863streeled
targeted1037483targeted
tarweed1137343tarwe_ed
teemed95114873t__eemed
teepee8314363t__eepee
temped113912893t__emped
themed125912583th__emed
theropod1445433theropod
thieved1434973th_ieved
thralled1245803thralled
thrashed1555363thrashed
thrawed1435583thr_awed
thread105011093thr_e_ad
threader1256733threader
threap11569663threap__
threapers1444773threapers
threaps12488643threap_s
threaten1146303threaten
threatened1442773threatened
three87526913thr_e_e_
threefold1652113threefold
threepence1752033threepence
threepenny1851013threepenny
threeping15104803threeping
threes97117323thr_e_es
threnode1255423threnode
thresher1455823thresher
threshes1437383threshes
thrilled1235493thrilled
thrived14458183thr_ived
throated1247923throated
throbbed1643163throbbed
throned115412173thr_oned
thronged13405333thronged
thrummed1642843thrummed
thrusted1265223thrusted
thumped15387413th_umped
tramped124312433t_ramped
trapped124512213t_rapped
treaded95014283t_readed
treated83618703t_reated
trebled1038483t_rebled
treed65626733t_r_e_ed
trekked1134343t_rekked
trended94011763t_rended
trepid9310083t_r_epid
tressed83714253t_ressed
tripped123911693t_ripped
tromped124210293t_romped
trooped104010723t_rooped
trouped103910983t_rouped
trumped12439713t_rumped
turreted935373turreted
tweeted11336583t_weeted
tweezed20274993t_weezed
unreeled91310333unreeled
unreeved12117673unreeved
wheeled14318463wh_eeled
wheepled1733293wh_eepled
wheezed23296453wh_eezed
whelped16355633wh_elped

Search took 7 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 Limit1461621176.72021750.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.92225814.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.