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

104 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
uptalked153305(None) 
outtalked1445512outtalked
peptalked1842472peptalked
stalked123811172_stalked
talked114015402__talked
unstalked1435522unstalked
untacked15239922untacked
uptake1236962upta_ke_
uptakes1336592upta_kes
uptalk1234652uptalk__
uptalks1333722uptalk_s
uptilted1174682uptilted
appalled1344813appalled
attacked15125113attacked
balked135219413__balked
calked134617403__calked
chalked17449863_chalked
metaled102913883metal_ed
metalled1148983metalled
outasked1337123outasked
outtasked1445373outtasked
outwalked1745293outwalked
packed154822603_p_acked
paiked135113433_p_aiked
paled85538723_p_al_ed
palled94625163_p_alled
palmed114314643_p_almed
palped114513643_p_alped
parked134425133_p_arked
peaked136117403_pea_ked
pealed95322803_peal_ed
petaled103614143petal_ed
petalled1138693petalled
planked143512283_planked
pranked143712093_pranked
psalmed1234503_psalmed
retacked15169273retacked
spalled103113123sp_alled
spanked143111723sp_anked
sparked143513133sp_arked
stacked143416123_stacked
staked114621943_sta_ked
staled74728103_stal_ed
stalker113912253_stalker
stalled83515683_stalled
tacked134723943__tacked
talced93811003__talced
talcked1446343__talcked
talker103916223__talker
tanked113919293__tanked
tasked114714643__tasked
totaled839693total_ed
totalled935843totalled
unasked122010023u_nasked
unbacked17268733unbacked
unbaked143312893unba_ked
unbaled103315963unbal_ed
uncaked143514353unca_ked
uncalled11810923uncalled
uncasked15278453uncasked
unfaked153211173unfa_ked
ungalled1078463ungalled
unhalved1556513unhalved
unmarked15248813unmarked
unmasked15267143unmasked
unpacked17268663unpacked
unraked122914013unra_ked
unranked1338563unranked
unsalted9510923unsalted
unslaked1338463unslaked
unstacked1636433unstacked
untagged1135973untagged
untaken1137643unta_ken
untamed102913223unta_med
untanned9279963untanned
untapped1376613untapped
untasted92011573untasted
untaxed152710583unta_xed
unthanked1764663unthanked
untilled9710563untilled
untilted9610893untilted
untracked16228373untracked
untucked15206053untucked
unvalued1266313unvalued
unwalled1288653unwalled
updarted1244313updarted
updated11369423upda_ted
upfolded1542883upfolded
upgazed2033423upga_zed
uplinked15254203uplinked
upmarket1644663upmarket
uppiled12216593uppil_ed
upraised11167413upraised
uprated103213323upra_ted
upscaled13144873upscal_ed
upstaged12135243upsta_ged
upstared11156573upsta_red
upstarted1244213upstarted
uptalking1643353uptalking
uptossed1142933uptossed
upturned11214013upturned
upwafted1742193upwafted
upwelled1434663upwelled
walked145313783__walked

Search took 8 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.1731032896.0
2DLD Change Limit1461621047.25020160.3
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.46923924.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.