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

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

88 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
stables9321907(None) 
sables85026691s_ables
stabiles10311401stabiles
stable83921641stable_
stabled103514951stabled
stabler94014931stabler
stablers103611151stablers
stablest103312941stablest
stales65538291sta_les
staples93617211staples
tables84524891_tables
ables75935542__ables
arables91814972arables
cables104527552_cables
eatables10169792eatables
enables92813122enables
fables114921672_fables
gables94222332_gables
gustables12165222gustables
notables10178242notables
potables12179702potables
ratables10159722ratables
restables111511422restables
retables101712672retables
sabes76437462s_ab_es
sable74732162s_able_
sabres85520862s_abres
sales56055592s_a_les
scabbles14167982scabbles
scabies11613332scabies
scales84529312sca_les
shales94731252sha_les
shambles15159042shambles
spales84728102spa_les
stabbed123510372stabbed
stabber113610152stabber
stabbers12268732stabbers
stabile9312062stabile_
stablish1348342stablish
stably113314122stabl_y
stabs76221382stab__s
stactes91914632stactes
staddles10258692staddles
stades74626242sta_des
stages75629492sta_ges
stakes103927292sta_kes
stale55637102sta_le_
staled74728102sta_led
staler64025822sta_ler
stalest73720172sta_lest
stalks104614552sta_lks
stalled83515682stalled
stalls64019932sta_lls
stances93715962stances
stanes64933402sta_nes
stapes85028732sta_pes
staple84415822staple_
stapled103613702stapled
stapler93913632stapler
staplers103111202staplers
stares66038752sta_res
starless81610842starless
starlet71620122starlet
starlets81610082starlets
startles82111962startles
starves104614552starves
stases64225562sta_ses
stashes103916172stashes
states64337082sta_tes
statues74614902statues
staves94525192sta_ves
steles63725662st_eles
stifles103013392stifles
stiles64328772st_iles
stoles63927672st_oles
storables1146282storables
stubbles1236842stubbles
stumbles1237492stumbles
styles94418652st_yles
suable83920552suable_
swales93920762swa_les
tabes76033922_tab_es
tablas83716162_tablas
table75429602_table_
tabled94020042_tabled
tablet84227642_tablet
tablets94714382_tablets
tales55451372_ta_les

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit107671882.97036252.9
3Display Results88880.0302933.3
 (SQL Overall)178691883.37352976.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.