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

(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
approachability296161(None) 
appealability2253954app_ea_lability
applicability24114064app_lic_ability
approachable2362254approachab_l__e
breathability2354075__breathability
detachability2454305__detachability
extractability28103545extr_actability
implacability2454875imp_lac_ability
improbability2464395impro__bability
improvability2564585impro__vability
intractability2155855intr_actability
leachability2255245___leachability
opposability2154385opp_o__sability
packability2446035__p__ackability
perishability2365225_per_ishability
placability2047135__p_lac_ability
probability2047695__pro__bability
profitability2355125__profitability
promotability2254795__promotability
roadability1757195___roa_dability
spreadability2154395_sprea_dability
stretchability2462135_stretchability
traceability1956525__tr_aceability
tractability1947085__tr_actability
unapproachably28141625unapproachab_l__y
untouchability2462285_untouchability
upgradability2253035upgr_a_dability
upgradeability2362425upgr_adeability
absorbability1962886a_bso_rbability
accountability2362616a_ccountability
actability1749076_____actability
adaptability2055216a___daptability
addressability2172166addr_essability
adoptability2054756a__do_ptability
adorability1746896a__do__rability
affectability2663856a__ffectability
affordability2552646a_ffo_rdability
agreeability1855156a_gr__eeability
amicability2047316a___mic_ability
appreciably2253046appr_eciab_l__y
approaching2162456approach____ing
approvably2253046appro__vab_l__y
arability14411006a__r____ability
attainability18103976a__ttainability
availability2055486a___vailability
brushability2253776__br_ushability
crossability1956096__cro_ssability
dissociability2262996disso_ciability
drapability1986466__dr_a_pability
drapeability2055906__dr_apeability
employability2553046emplo__yability
enforceability2472546_enforceability
erasability1668926__er_a_sability
expandability2853686exp__andability
exportability2774246exp_o_rtability
hatchability2553776___hatchability
hypnotizability3771046hypnotizability
impalpability2454106imp__alpability
impassability2265256imp__assability
impeccability2654466imp__eccability
imperishability2772716imperishability
impregnability24163226impr_egnability
inapplicability26102926inapp_lic_ability
inapproachable25201756inapproachab_l__e
ineffaceability2862276ineffaceability
insociability2056226_inso_ciability
marriageability23111656marriageability
operability1848846oper____ability
palatability1946376__pala_tability
palpability2046326__p__alpability
perdurability2154676_per_durability
perfectibility2663266_perfectibility
performability2663026_performability
permeability2157166_per__meability
playability2146016__p_la_yability
portability1849556__p_o_rtability
potability1749806__p_o__tability
practicability2553316__pr_acticability
predictability2454006_predictability
preferability2355246__preferability
pregnability2056156__pr_egnability
printability1946856__pr_intability
processability2363036__processability
programmability27101516__programmability
punishability2353296__punishability
readability1748066___rea_dability
repairability2055846rep__airability
repeatability2056236rep_ea_tability
replicability2255596rep_lic_ability
reproachable2152616reproachab_l__e
reproducibility2571556reproducibility
separability1946906sep__a_rability
serviceability2462866_serviceability
sociability1847916___so_ciability
supportability2362236suppo_rtability
trainability1746846__tr_ainability
treatability1747426__trea_tability
unapproachable25232016unapproachab_l__e
unpalatability2163086unpala_tability
unsociability2054896_unso_ciability
washability2245316____washability

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 Filter178691950240.1101624463.6
2DLD Change Limit950241017.51612642.9
3Display Results1011010.0761328.9
 (SQL Overall)1786911017.70223200.6
 
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.