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

82 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
stanchest1421821(None) 
stanches132312791stanches_
staunchest1543121staunchest
stances93715962stanc_es_
stanched14208902stanche_d
stancher13198812stanche_r
stanchers14206812stanchers
starches131912912starches_
starchiest1547192starchiest
staunches1444602staunches_
stenches132110292stenches_
stenchiest1545082stenchiest
blanches153311603blanches_
branches153613803branches_
branchiest1746713branchiest
chanciest1638383chanciest
cranches153114543cranches_
fanciest133612713_fanciest
gauchest1436293_gauchest
manches143818623_manches_
manchet143317783_manche_t
manchets15269573_manchets
planches153111863planches_
planchet152511963planche_t
planchets16236743planchets
ranches123620113_ranches_
sachet114725773s_a_che_t
sachets123914103s_a_chets
sandiest93218693s_andiest
sanest64426693s_an__est
sauciest10310983s_auciest
scantest101710183scan_test
scantiest112611013scantiest
scarcest12169173scarc_est
seances93015343seanc_es_
searches132112903searches_
skankiest12145713skankiest
slackest14289403sla_ckest
slangiest10129083slangiest
slatches131511533slatches_
snatches131410713snatches_
snatchiest1545163snatchiest
spaciest122310903spa_ciest
stablest103312943sta_blest
stactes91914633sta_ctes_
staggiest11148263staggiest
stagiest91613413sta_giest
staidest939803sta_idest
staithes1138953staithes_
stalest73720173sta__lest
stalkiest1347913stalkiest
stance84316913stanc_e__
stanch113812373stanch___
stanching1538083stanching
stanchion1444643stanchion
stanchly1644443stanch_ly
standees93310143standees_
standfast1343913standfast
stanes64933403stan__es_
stanines85115673stanines_
starched14199313starche_d
starkest1239723sta_rkest
starriest9159773starriest
stashes103916173sta_shes_
staunched1553473staunche_d
stauncher1443513staunche_r
staunchness1651693staunchness
stingiest10209773stingiest
stinkiest13198463stinkiest
stitches131410593stitches_
stoniest8413543ston_iest
strangest103210843stran_gest
strictest1147293strictest
swankest15105933swan_kest
swankiest16136213swankiest
swatches16169963swatches_
taches114224173_ta_ches_
tachist12613293_ta_chist
tangiest92915223_tangiest
tannest72617853_tan_nest
tenches123515523_tenches_
tranches132915513tranches_

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 Filter1786911486410.423422437.4
2DLD Change Limit148641826.48322927.8
3Display Results82820.0302733.3
 (SQL Overall)178691826.93625762.8
 
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.