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

94 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
admirability205567(None) 
adorability1746872ad_orability
advisability2155032advisability
amiability1748692a_mi_ability
amicability2047282a_micability
adaptability2055203adaptability
admirabilities1956023admirabilities
admirably1743883admirab_l__y
admiralty1552243admira__l_ty
admissibility2183083admissibility
adoptability2054743adoptability
alterability1747113alterability
amenability1847463a_menability
arability14411003a___rability
availability2055473availability
desirability1847243desirability
disability1649743_d_isability
drivability2046773_drivability
durability1647713_d_urability
memorability2146433memorability
absorbability1962884absorbability
actability1749064a__ctability
adjustability2652964adjustability
admirable1445434admirab_l__e
affability2145674a__ffability
affordability2552644affordability
agreeability1855144agreeability
alienability1745684alienability
amorality1446714a_mora__lity
applicability24114064applicability
assignability1962864assignability
assimilability2162464assimilability
assumability1954014assumability
attainability18103974attainability
audibility1645824audi__bility
bearability1847324_bearability
coilability1847924_coilability
comparability2454884comparability
curability1747854__curability
damageability2253174damageability
decidability2145744decidability
deniability1748724_deniability
drapability1986444_drapability
drillability1854614_drillability
drinkability2254674_drinkability
driveability2155074_driveability
dyeability1945884_d_yeability
edibility1546914ed_i__bility
educability1946244ed_ucability
enumerability2074274enumerability
equitability2645774equitability
excitability2655674excitability
fatigability2154984fatigability
formidability2463964formidability
friability1847884_fri_ability
germinability2155044germinability
habitability2255084habitability
heritability2047964heritability
honorability2055804honorability
ignitability1856034ignitability
immovability2454834immovability
immutability2155884immutability
inability14411084___inability
inadvisability2374154inadvisability
indomitability2254804indomitability
insurability1757194insurability
inviability1978724invi_ability
irritability1747444irritability
liability14128484__li_ability
likability1996124__likability
livability1886744__livability
machinability2573904machinability
mailability1847284_mailability
movability2077224__movability
mutability1748074__mutability
navigability2155424navigability
operability1848844_operability
pliability1748044_pli_ability
reliability1649454reli_ability
removability2255724removability
repairability2055834repairability
separability1946904separability
severability2046744severability
sociability1847914soci_ability
stainability1755654stainability
suitability1647114_suitability
summability2045434sum_mability
tolerability1776284tolerability
trainability1746814trainability
undesirability2063914undesirability
variability1947504vari_ability
venerability2046764venerability
viability1767874__vi_ability
wearability1947094_wearability

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 Filter1786911247900.1561145455.1
2DLD Change Limit124790947.84315911.0
3Display Results94940.110854.5
 (SQL Overall)178691948.10922036.1
 
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.