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

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

89 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
defensibilities216404(None) 
defeasibilities2153811defeasibilities
defensibility2254443defensibilit__y
dependabilities2155243dependabilities
extensibilities2493463extensibilities
feasibilities1866563__feasibilities
infeasibilities2064713infeasibilities
insensibilities1764903insensibilities
reversibilities2084153reversibilities
sensibilities1557363__sensibilities
accessibilities2162974accessibilities
deductibilities2183064deductibilities
defeasibility2254184defeasibilit__y
delectabilities2065554delectabilities
deniabilities1649764d__eniabilities
detectabilities2065824detectabilities
deterrabilities1875384deterrabilities
detonabilities1756704deton_abilities
digestibilities1963284digestibilities
divisibilities2064054d_ivisibilities
expansibilities2693384expansibilities
fungibilities1964504__fungibilities
fusibilities1746224__f_usibilities
infusibilities1955454inf_usibilities
refundabilities2153924refundabilities
vendibilities1955874__vendibilities
admissibilities2063275admissibilities
affectabilities2553985affectabilities
alienabilities1656205alien_abilities
amenabilities1778835_amen_abilities
credibilities1856065_cre_dibilities
debilities13411295d__e___bilities
decidabilities2046235de_cidabilities
defensible1644595defensib_l___e_
desirabilities1747525de_sirabilities
detachabilities2354145detachabilities
disabilities15411105d___isabilities
disposabilities2053545disposabilities
drinkabilities2155035d_rinkabilities
dyeabilities1847865d_ye__abilities
edibilities1458705___e_dibilities
electabilities1857565_electabilities
eligibilities1655645_e_ligibilities
erasabilities1549605_e_rasabilities
erodibilities1656885_e_rodibilities
expendabilities2774375expendabilities
extendabilities2564165extendabilities
fallibilities1854545__fallibilities
flexibilities2564015__flexibilities
frangibilities2054035_frangibilities
illegibilities1754405ille_gibilities
impassibilities21184665impassibilities
impossibilities21174225impossibilities
indefensibility2463205indefensibilit__y
indelibilities1755555inde_libilities
infallibilities2063605infallibilities
inflexibilities2763245inflexibilities
insensitivities1882715insensitivities
intangibilities1864475intangibilities
invincibilities2293725invincibilities
invisibilities1956115_invisibilities
legibilities1547475__le_gibilities
negligibilities1962575negligibilities
openabilities1748615_open_abilities
patentabilities1995335patentabilities
penetrabilities1965325penetrabilities
plausibilities1873755_plausibilities
possibilities1756055__possibilities
preferabilities2254605prefe_rabilities
prehensilities1962175prehens__ilities
reducibilities1954165re_ducibilities
reeligibilities1862975reeligibilities
reformabilities2264535reformabilities
remediabilities2054615remediabilities
renewabilities1956205rene_wabilities
rentabilities15411235__rentabilities
repeatabilities1955915repeatabilities
resectabilities1956015resectabilities
resistibilities1753975resistibilities
reusabilities1549265__reusabilities
risibilities1448625___risibilities
sensitivities1654535__sensitivities
severabilities1947435seve_rabilities
tangibilities1655485__tangibilities
tenabilities14911485__ten_abilities
tensilities1147655__tens__ilities
untenabilities1656995unten_abilities
venerabilities1967355vene_rabilities
visibilities1747375___visibilities

Search took 5 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 Filter178691658740.0961861364.6
2DLD Change Limit65874894.54614490.5
3Display Results89890.0631412.7
 (SQL Overall)178691894.70537979.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.