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

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

52 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
disinheritances21121391disinheritances_
disinheritance20101652disinheritance__
inheritances1753924___inheritances_
disinherited1753415disinherit___e_d
disinheriting1853475disinheritin___g
disinherits1554015disinherit____s_
inheritance1654115___inheritance__
disinfectants1972376disinfe_ctan_ts_
disinfestants1772486disinfe_stan_ts_
disinherit1455506disinherit______
disseverances1962116dissever__ances_
inheritrices1752746___inheritrices_
deliverances18142697deli_ver__ances_
desinences1347217desin_e____nces_
desistances1444197desi____stances_
disaffirmances25101537disaffir_mances_
disappearances2171317disappe_arances_
discordances1853687dis__cor_dances_
disherited1546707dis__herit___e_d
disheriting1646457dis__heritin___g
disherits1348237dis__herit____s_
disincentives1962867disince_nt_ives_
disinclines1454707disin_cli__n_es_
disinfectant1873457disinfe_ctan___t
disinfections1954887disinfection__s_
disinfestant1673227disinfe_stan___t
disinhibited1962297disinhibit___e_d
disinhibiting2062497disinhibitin___g
disinhibitions2062597disinhibit_ions_
disinhibits1752187disinhibit____s_
disintegrates1583127disinte_gra_tes_
disinterest1255617disinter_____est
disinterments1664867disinter_men_ts_
disintoxicates2471877disintoxica_tes_
disinvites1445157disin__vit___es_
disobediences1961497dis_obedi_ences_
dissertates1245347dis__ser_ta_tes_
disseverance1862317dissever__ance__
distances12311657dis______tances_
disturbances1752457dis__tur_bances_
domineeringness197657domineeringn_ess
hesitances1545547_____hesitances_
inhabitancies2061627___inhabitancies_
inherences1568977___inher__ences_
inheritable1647247___inheritable__
inheritress1452417___inherit__ress
inheritrixes2252117___inheritrixes_
insincerities1562797insincerit__ies_
invariances1653887___invari_ances_
itinerancies1452797_itin_er__ancies_
misunderstands187707misunderstan_ds_
sincerities1347097__sincerit__ies_

Search took 10 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 Filter178691950240.360496363.9
2DLD Change Limit95024529.26610255.1
3Display Results52520.0461130.4
 (SQL Overall)178691529.67218475.1
 
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.