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

77 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
weatherability257286(None) 
wearability1947103wea___rability
alterability1747124__alterability
bearability1847334bea___rability
breathability2354084breath__ability
deliverability23102674deliverability
denumerability2262704denumerability
deterrability1974994de_terrability
enumerability2074284_enumerability
filterability2153704filt_erability
inalterability1954564inalterability
leachability2255254leach__ability
measurability2054474mea_surability
recoverability2473204recoverability
severability2046754se__verability
sinterability1855214sint_erability
unalterability1963474unalterability
venerability2046774ve__nerability
washability2245324w_ash__ability
wettability1946484we_t__tability
admirability2055715__admirability
adorability1746905__a_dorability
agreeability1855165__agreeability
alienability1745695__alienability
amenability1847495__a_menability
arability14411015__a___rability
believability2353755be_lievability
changeability2453345change_ability
desirability1847275de__sirability
detachability2454315de_tachability
detectability2155665de_tectability
detonability1856145de_t_onability
drapeability2055915dra_pe_ability
ethereality1753165_e_ther_eality
extendability2653595_extendability
extrudability2673145_extrudability
fatigability2154995_fat_igability
hatchability2553775_hat_chability
inalienability1954555inalienability
integrability1956585_integrability
intolerability1964525intolerability
machinability2573915_machinability
malleability1954845_malle_ability
marketability2454135_marketability
meltability1848685melt___ability
memorability2146445me__morability
mensurability2054385me_nsurability
metastability2055575me_tastability
operability1848855___operability
patentability2054785_patentability
penetrability2055215pe_netrability
perdurability2154685pe_rdurability
permeability2157175pe_rme_ability
pleasurability2171955plea_surability
preferability2355255_preferability
readability1748075rea___dability
reasonability1854795rea_sonability
rectifiability2462575rectifiability
rememberability2671495rememberability
renewability2055835re__newability
rentability16410195rent___ability
repairability2055855re_pairability
retrievability2252905retrievability
separability1946915se__parability
shareability2054925sha_re_ability
solderability1963385_solderability
tenability1549125___t_enability
testability1648805test___ability
tolerability1776295__tolerability
traceability1956535tra_ce_ability
transferability2361935transferability
treatability1747435treat___ability
unanswerability2362105unanswerability
untenability1756425_unt_enability
vulnerability2153265_vulnerability
weatherizing2854355weather__izing
weatherly1844405weather___l__y

Search took 7 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.343520965.0
2DLD Change Limit95024775.87616171.5
3Display Results77770.0631222.2
 (SQL Overall)178691776.28228444.9
 
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.