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

101 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
starchier143664(None) 
searcher13209102search_er
snatchier1455352snatchier
stancher13198812stanch_er
starched14199312starch_ed
starches131912912starch_es
starchiest1547192starchiest
starchily1745012starchily
starching1538592starching
starrier8279462star_rier
stenchier1445332stenchier
swarthier1543782swarthier
torchier1337462_torchier
achier113914263__a_chier
anarchies1448183anarchies
archer115016243__arch_er
autarchies1544993autarchies
beachier1538803bea_chier
branchier1637133branchier
catchier15329863_catchier
churchier1944153churchier
diarchies1546753diarchies
dyarchies1844033dyarchies
earthier1137443_earthier
eparchies1646973eparchies
exarchies2145213exarchies
itchier12247673it__chier
leachier1337253lea_chier
marcher143912973_march_er
marshier1337593_marshier
octarchies1743693octarchies
patchier15319663_patchier
peachier1548623pea_chier
poachier1556823poa_chier
sarkier113413313s_ar_kier
saucier9810283s_auc_ier
scarcer113911373scarc__er
scarier94017873scar__ier
scarifier1446653scarifier
scarrier10298453scar_rier
scorcher15196793scorch_er
scratchier1744343scratchier
searched14209253search_ed
searchers14197353search_ers
searches132112903search_es
searching1538343searching
sketchier1853413sketchier
slouchier1443603slouchier
smarmier1235033smar_mier
smutchier1643503smutchier
snarkier12336513snar_kier
snarlier8278183snar_lier
snatcher13167763snatch_er
spacier114011633spa_c_ier
sparkier14298033spar_kier
sparklier1554363sparklier
sparrier10329143spar_rier
stacker134416263sta_c_ker
staggier10167513sta_ggier
stagier83513443sta__gier
stalkier1257073sta_lkier
stanched14208903stanch_ed
stanchers14206813stanch_ers
stanches132312793stanch_es
stanching1538083stanching
stanchion1444643stanchion
starch113013203starch___
starchiness1643943starchiness
starchy15286743starch__y
starer64027363star___er
stargazer1942593stargazer
starker114114693star__ker
starship1348143starshi_p
starships1447663starships
starter73817883star__ter
startler8248793star_tler
starver104611993star__ver
statelier945653statelier
stauncher1443513staunch_er
stealthier1342863stealthier
stickier14229763st_ickier
stitcher13168393stitch_er
stockier14217253st_ockier
stormier1036103stor_mier
strappier1345143strappier
strawier1137493st_rawier
stretchier1544483stretchier
stripier1058863st_ripier
sturdier9216963stur_dier
tackier133712523_ta_ckier
tardier859719993_tar_dier
tarrier74323173_tar_rier
tarsier74119253_tar_sier
tartier74123263_tar_tier
techier1269243_t_echier
tetchier1336453_tetchier
thatchier1743983thatchier
torchiere1443573_torchiere
torchiers1445073_torchiers
touchier1347383_touchier
trashier113210103_trashier

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411016.83021763.0
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.31224438.0
 
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.