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

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

70 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
appearances175369(None) 
appearance1654061appearance_
reappearances1961772reappearances
aberrances1475433a_berrances
appetences1644593appe_tences
appliances1643973app_liances
clearances1444793_clearances
disappearances2171313disappearances
esperances1446253espe_rances
nonappearances2071373nonappearances
pleasances1444193_pleasances
reappearance1882033reappearance_
aberrance1355694a_berrance_
aberrancies1593914a_berrancies
abeyances1644614a_be_yances
acceptances1653174acceptances
adamances1445034a__damances
adherences1664884adhe_rences
allegiances14103064allegiances
amperages1447684ampe_ra_ges
appanages1443994app_ana_ges
apparats1287094app_ara__ts
apparatus1353864app_ara_tus
apparatuses1552204app_aratuses
appealable1643854appealable_
appeared1336144appear___ed
appearing1436894appearin__g
appears11308954appear____s
appeasable1644594appeasable_
appeases1238664appe__a_ses
appellants1443964appellan_ts
appendages1653244appenda_ges
appendants1544064appendan_ts
appendices1743464appe_ndices
appetence1544994appe_tence_
appetencies1753734appe_tencies
applesauces1751714applesauces
appliance1544504app_liance_
appraises1347424app__raises
arrearages1143034arreara_ges
ascendances16123834ascendances
asperates11312554aspe_ra_tes
assurances1244694a_ssurances
attendances1483194attendances
clearance1345114_clearance_
defeasances1752284defeasances
dependances1754854dependances
disappearance2061364disappearance_
esperance1346694espe_rance_
expectances2493344expectances
feasances1445404__feasances
forbearances1951934forbearances
happenchances278914happenchances
happenstances2261154happenstances
impedances1744504impe_dances
iterances1148914_ite_rances
malfeasances1961424malfeasances
nonappearance1971674nonappearance_
parlances1348964__p_arlances
penances12312444__pe_nances
penetrances1544804penetrances
pleasance1344304_pleasance_
prances113618784__p__rances
prearranges1453044_prearranges
repentances1556114repentances
severances1546784seve_rances
superraces1449864superra_ces
temperances1754734tempe_rances
tolerances1245994tole_rances
utterances1245084utte_rances

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 Filter1786911488190.420425454.8
2DLD Change Limit148819708.19018170.8
3Display Results70700.0302333.3
 (SQL Overall)178691708.64020681.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.