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
admirability205571(None) 
adorability1746902ad_orability
advisability2155062advisability
amiability1748742a_mi_ability
amicability2047322a_micability
adaptability2055223adaptability
admirabilities1956053admirabilities
admirably1743883admirab_l__y
admiralty1552243admira__l_ty
admissibility2183123admissibility
adoptability2054763adoptability
alterability1747123alterability
amenability1847493a_menability
arability14411013a___rability
availability2055493availability
desirability1847273desirability
disability1649773_d_isability
drivability2046793_drivability
durability1647733_d_urability
memorability2146443memorability
absorbability1962894absorbability
actability1749084a__ctability
adjustability2652984adjustability
admirable1445434admirab_l__e
affability2145684a__ffability
affordability2552654affordability
agreeability1855164agreeability
alienability1745694alienability
amorality1446724a_mora__lity
applicability24114064applicability
assignability1962874assignability
assimilability2162474assimilability
assumability1954024assumability
attainability18103984attainability
audibility1645834audi__bility
bearability1847334_bearability
coilability1847934_coilability
comparability2454904comparability
curability1747864__curability
damageability2253194damageability
decidability2145744decidability
deniability1748724_deniability
drapability1986474_drapability
drillability1854634_drillability
drinkability2254694_drinkability
driveability2155094_driveability
dyeability1945884_d_yeability
edibility1546924ed_i__bility
educability1946244ed_ucability
enumerability2074284enumerability
equitability2645774equitability
excitability2655674excitability
fatigability2154994fatigability
formidability2463994formidability
friability1847894_fri_ability
germinability2155064germinability
habitability2255094habitability
heritability2047984heritability
honorability2055814honorability
ignitability1856054ignitability
immovability2454844immovability
immutability2155894immutability
inability14411104___inability
inadvisability2374194inadvisability
indomitability2254834indomitability
insurability1757224insurability
inviability1978744invi_ability
irritability1747484irritability
liability14128484__li_ability
likability1996124__likability
livability1886744__livability
machinability2573914machinability
mailability1847304_mailability
movability2077234__movability
mutability1748074__mutability
navigability2155444navigability
operability1848854_operability
pliability1748054_pli_ability
reliability1649464reli_ability
removability2255734removability
repairability2055854repairability
separability1946914separability
severability2046754severability
sociability1847924soci_ability
stainability1755684stainability
suitability1647114_suitability
summability2045454sum_mability
tolerability1776294tolerability
trainability1746854trainability
undesirability2063934undesirability
variability1947524vari_ability
venerability2046774venerability
viability1767874__vi_ability
wearability1947104_wearability

Search took 8 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.1431249587.4
2DLD Change Limit124790946.96617914.2
3Display Results94940.0501880.0
 (SQL Overall)178691947.15924960.3
 
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.