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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
alienability174569(None) 
alterability1747122alterability
amenability1847492a_menability
inalienability1954552inalienability
agreeability1855163agreeability
alienabilities1656223alienabilities
amiability1748743ami__ability
amicability2047323ami_cability
assignability1962873assignability
believability2353753believability
cleanability1955223cleanability
inability14411103__i_nability
liability14128483_li__ability
likability1996123_li_kability
livability1886743_li_vability
liveability1945793_liveability
malleability1954843malle_ability
openability1846933_openability
pliability1748053pli__ability
tenability1549123__tenability
untenability1756423untenability
acceptability2454124acceptability
actability1749084a__ctability
adaptability2055224adaptability
admirability2055714admirability
adoptability2054764adoptability
adorability1746904a_dorability
advisability2155064advisability
affability2145684a__ffability
affectability2663854affectability
alienable1146934alienab_l__e
appealability2253964appealability
applicability24114064appli_cability
arability14411014a___rability
assumability1954024assumability
attainability18103984attainability
availability2055494availability
biddability2043844_biddability
coilability1847934coi_lability
deliverability23102674deliverability
deniability1748724__deniability
dependability2254864dependability
detonability1856144detonability
dilatability1845454dilatability
disability1649774_di_sability
drillability1854634drillability
drinkability2254694drinkability
drivability2046794dri_vability
driveability2155094driveability
dyeability1945884_dye_ability
electability1947054electability
eligibility1754834eli_gibility
expendability2853844expendability
extendability2653594extendability
falsifiability2591744falsifiability
fashionability2571954fashionability
fatigability2154994fati_gability
filterability2153704filterability
fishability2245284_fishability
flammability2453904flammability
flexibility2653294fl_exibility
friability1847894fri__ability
habitability2255094habi_tability
ignobility1654144__ignobility
illegibility1854424illegibility
inalterability1954564inalterability
lability13710834_l___ability
legibility1645914_l_egibility
lineality1246424_linea__lity
lovability18106934_l_ovability
machinability2573914machinability
machineability26132504machineability
mailability1847304mai_lability
marketability2454134marketability
navigability2155444navi_gability
operability1848854_operability
palatability1946384pal_atability
palpability2046334pal__pability
patentability2054784patentability
placability2047144pl_acability
playability2146024pl_ayability
pregnability2056164pregnability
printability1946864printability
reliability1649464reli__ability
renewability2055834renewability
rentability16410194__rentability
salability1548524sal___ability
severability2046754severability
sewability1846854__sewability
solderability1963384solderability
stainability1755684stainability
suitability1647114sui_tability
tolerability1776294tolerability
trainability1746854trainability
tunability1546984__tunability
unalterability1963474unalterability
variability1947524vari__ability
venerability2046774venerability
viability1767874_vi__ability
violability1946274_violability
vulnerability2153264vulnerability

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.436409841.7
2DLD Change Limit1247901016.58018965.0
3Display Results1011010.0601683.3
 (SQL Overall)1786911017.07625253.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.