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

93 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
stablish134834(None) 
establish1444741establish
smallish1346572smallish
stabilise1197082stabilise
stables93219072stables_
stablest103312942stablest
stabling112913652stabling
stablished1644222stablished
stablishes1545372stablishes
standish1238542standish
starfish1438082starfish
stylish13197442st_ylish
tallish103313582_tallish
ablush1147223__ablush
abolish12311503__abolish
babyish1736513_babyish
carlish12312763_carlish
chablis14368563chablis_
established1753103established
establisher1652833establisher
establishes1653453establishes
feeblish1644163feeblish
palish114718273_pa_lish
publish1447913_publish
reestablish1653103reestablish
sablefish1742903s_ablefish
sables85026693s_ables_
sailfish1446053s_ailfish
saltish10312163s_altish
sawfish1637683s_awfish
scablike1635553scablike
scampish1744893scampish
slablike1435673slablike
slavish1338233sla_vish
slobbish1544263slobbish
snappish1545233snappish
snobbish1544213snobbish
sparkish17276973sparkish
squallish2143403squallish
stabbing13238763stabbing
stabile9312063stab_ile
stabiles10311403stabiles
stabilised13104593stabilised
stabilises12116013stabilises
stability14410083stability
stabilize20116563stabilize
stable83921643stabl__e
stabled103514953stabl_ed
stabler94014933stabl_er
stablers103611153stablers
stablings12256103stablings
stablishing1753543stablishing
stably113314123stabl__y
stabs76221383stab__s_
stales65538293sta_les_
stalest73720173sta_lest
staling83925423sta_ling
stalks104614553sta_lks_
stalling95116703stalling
stallion837513stallion
stalls64019933sta_lls_
staples93617213staples_
stapling112813153stapling
starless81610843starless
starlight1345913starlight
starlike1238813starlike
starling93017123starling
starlit71512913starli_t
stash84916973sta___sh
stasis63116873sta_sis_
statism9412283sta_tism
statist7317723sta_tist
statolith1245533statolith
steepish1375823steepish
stiffish1745243stiffish
stockish17186043stockish
stonish10410653st_onish
stoutish1145903stoutish
studfish1544523studfish
stylise10208953st_ylise
stylist102110283st_ylist
swainish1444753swainish
swampish1844173swampish
tabbis102910863_tabbis_
tablas83716163_tablas_
tables84524893_tables_
tabling103216033_tabling
tabulis938833_tabulis_
tallis63319963_tallis_
tallith102913063_tallith
tannish101610573_tannish
tarnish101611873_tarnish
tartish101512633_tartish

Search took 9 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.706253103.4
2DLD Change Limit146162937.56019333.6
3Display Results93930.0332818.2
 (SQL Overall)178691938.29921531.6
 
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.