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

65 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
delectability215567(None) 
detectability2155661detectability
electability1947051_electability
resectability2056092resectability
affectability2663853affectability
deductibility2253513deductibility
delectabilities2065563delectabilities
delectably18125683delectab_l__y
dependability2254863dependability
detachability2454313detachability
deterrability1974993deterrability
dilatability1845453dil_atability
ineluctability2185053ineluctability
meltability1848683mel__tability
repeatability2056243repeatability
respectability2353973respectability
acceptability2454124acceptability
actability1749084___actability
believability2353754believability
cleanability1955224_cleanability
decidability2145744de_cidability
defeasibility2254204defeasibility
defensibility2254454defensibility
delectable15247384delectab_l__e
delectables16144334delectab_l_es
deliverability23102674deliverability
deniability1748724d__eniability
desirability1847274de_sirability
detectabilities2065824detectabilities
detonability1856144de_tonability
digestibility2053724digestibility
dyeability1945884d_ye__ability
educability1946244_educ_ability
electabilities1857584_electabilities
electricity1854954_elect_ricity
equitability2645774_equitability
erectility1546264_erect__ility
excitability2655674_excitability
heritability2047984he_ritability
impeccability2654464impeccability
indefectibility2673314indefectibility
leachability2255254le_achability
metastability2055574metastability
palatability1946384pal_atability
patentability2054784patentability
penetrability2055214penetrability
perfectibility2663264perfectibility
placability2047144_plac_ability
predictability2454014predictability
presentability2164504presentability
preventability2464064preventability
reliability1649464rel__iability
remediability2154684remediability
renewability2055834rene_wability
rentability16410194__rentability
replicability2255604replic_ability
reputability1946984re_putability
selectivity1954784select__ivity
severability2046754seve_rability
testability1648804__testability
tolerability1776294tole_rability
tractability1947094_tractability
treatability1747434_treatability
venerability2046774vene_rability
wettability1946484__wettability

Search took 6 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.346516448.0
2DLD Change Limit95024655.10618610.3
3Display Results65650.0461413.0
 (SQL Overall)178691655.49832501.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.