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
approachability296162(None) 
appealability2253964app_ea_lability
applicability24114064app_lic_ability
approachable2362254approachab_l__e
breathability2354085__breathability
detachability2454315__detachability
extractability28103555extr_actability
implacability2454885imp_lac_ability
improbability2464405impro__bability
improvability2564595impro__vability
intractability2155865intr_actability
leachability2255255___leachability
opposability2154395opp_o__sability
packability2446045__p__ackability
perishability2365235_per_ishability
placability2047145__p_lac_ability
probability2047705__pro__bability
profitability2355135__profitability
promotability2254805__promotability
roadability1757205___roa_dability
spreadability2154405_sprea_dability
stretchability2462135_stretchability
traceability1956535__tr_aceability
tractability1947095__tr_actability
unapproachably28141625unapproachab_l__y
untouchability2462285_untouchability
upgradability2253045upgr_a_dability
upgradeability2362435upgr_adeability
absorbability1962896a_bso_rbability
accountability2362616a_ccountability
actability1749086_____actability
adaptability2055226a___daptability
addressability2172176addr_essability
adoptability2054766a__do_ptability
adorability1746906a__do__rability
affectability2663856a__ffectability
affordability2552656a_ffo_rdability
agreeability1855166a_gr__eeability
amicability2047326a___mic_ability
appreciably2253046appr_eciab_l__y
approaching2162456approach____ing
approvably2253046appro__vab_l__y
arability14411016a__r____ability
attainability18103986a__ttainability
availability2055496a___vailability
brushability2253786__br_ushability
crossability1956106__cro_ssability
dissociability2262996disso_ciability
drapability1986476__dr_a_pability
drapeability2055916__dr_apeability
employability2553046emplo__yability
enforceability2472556_enforceability
erasability1668936__er_a_sability
expandability2853696exp__andability
exportability2774256exp_o_rtability
hatchability2553776___hatchability
hypnotizability3771046hypnotizability
impalpability2454116imp__alpability
impassability2265266imp__assability
impeccability2654466imp__eccability
imperishability2772726imperishability
impregnability24163236impr_egnability
inapplicability26102926inapp_lic_ability
inapproachable25201756inapproachab_l__e
ineffaceability2862286ineffaceability
insociability2056226_inso_ciability
marriageability23111666marriageability
operability1848856oper____ability
palatability1946386__pala_tability
palpability2046336__p__alpability
perdurability2154686_per_durability
perfectibility2663266_perfectibility
performability2663036_performability
permeability2157176_per__meability
playability2146026__p_la_yability
portability1849566__p_o_rtability
potability1749816__p_o__tability
practicability2553326__pr_acticability
predictability2454016_predictability
preferability2355256__preferability
pregnability2056166__pr_egnability
printability1946866__pr_intability
processability2363046__processability
programmability27101526__programmability
punishability2353306__punishability
readability1748076___rea_dability
repairability2055856rep__airability
repeatability2056246rep_ea_tability
replicability2255606rep_lic_ability
reproachable2152616reproachab_l__e
reproducibility2571556reproducibility
separability1946916sep__a_rability
serviceability2462866_serviceability
sociability1847926___so_ciability
supportability2362246suppo_rtability
trainability1746856__tr_ainability
treatability1747436__trea_tability
unapproachable25232016unapproachab_l__e
unpalatability2163096unpala_tability
unsociability2054896_unso_ciability
washability2245326____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.360496363.9
2DLD Change Limit950241016.87313825.7
3Display Results1011010.0631603.2
 (SQL Overall)1786911017.29624491.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.