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 “starchiest” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
starchiest154718(None) 
snatchiest1545152snatchiest
stanchest14218212stanch_est
starches131912912starch_es_
starchier1436642starchie_r
starchiness1643942starchiness
starriest9159762star_riest
stenchiest1545082stenchiest
swarthiest1644742swarthiest
torchiest1438032_torchiest
achiest12315183__a_chiest
anarchies1448183anarchies_
anarchist1447563anarchi_st
autarchies1544993autarchies_
beachiest1638443bea_chiest
branchiest1746713branchiest
catchiest1638313_catchiest
churchiest2044053churchiest
diarchies1546753diarchies_
dyarchies1844033dyarchies_
earthiest1259103_earthiest
eparchies1646973eparchies_
exarchies2145213exarchies_
itchiest1336523it__chiest
leachiest1437243lea_chiest
marshiest1438103_marshiest
octarchies1743693octarchies_
patchiest1638353_patchiest
peachiest1638523pea_chiest
poachiest1636883poa_chiest
sarkiest123615063s_ar_kiest
sauciest10310973s_auc_iest
scarcest12169173scarc__est
scariest101615943scar__iest
scarriest11188393scar_riest
scratchiest1844143scratchiest
searches132112903search_es_
searchless1543373searchless
sketchiest1943163sketchiest
slouchiest1543973slouchiest
smarmiest1335903smar_miest
smutchiest1743263smutchiest
snarkiest13207633snar_kiest
snarliest91810203snar_liest
spaciest122310893spa_c_iest
sparkiest15188093spar_kiest
sparkliest1644573sparkliest
sparriest11198783spar_riest
staggiest11148253sta_ggiest
stagiest91613403sta__giest
stalkiest1347903sta_lkiest
stanches132312793stanch_es_
starched14199313starch_e_d
starchily1745013starchi_ly
starching1538593starchi_ng
starkest1239723star__kest
starships1447663starships_
stateliest1046353stateliest
staunchest1543123staunch_est
stealthiest1443303stealthiest
stickiest15229603st_ickiest
stockiest15207753st_ockiest
stormiest1137003stor_miest
strappiest1444373strappiest
strawiest1237213st_rawiest
stretchiest1644193stretchiest
stripiest1138013st_ripiest
sturdiest10207393stur_diest
tachist12613293_ta_chi_st
tackiest143112433_ta_ckiest
tardiest93515243_tar_diest
tarriest83215003_tar_riest
tartiest82718313_tar_tiest
techiest1359833_t_echiest
tetchiest1445793_tetchiest
thatchiest1844163thatchiest
touchiest1437083_touchiest
trashiest123110633_trashiest

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 Filter1786911406030.420425454.8
2DLD Change Limit140603786.12622951.8
3Display Results78780.0302600.0
 (SQL Overall)178691786.57627173.2
 
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.