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

150 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
amicability204732(None) 
amiability1748741ami_ability
admirability2055712admirability
amenability1847492amenability
mailability1847302mailability
actability1749083a_ctability
adorability1746903adorability
advisability2155063advisability
affability2145683a_ffability
alienability1745693alienability
amicabilities19197913amicabilities
amicably1746333amicab_l__y
applicability24114063applicability
arability14411013a__rability
availability2055493availability
coilability1847933coilability
disability1649773_disability
drivability2046793drivability
educability1946243educability
fatigability2154993fatigability
friability1847893fri_ability
habitability2255093habitability
inability14411103__inability
liability14128483_li_ability
likability1996123_likability
livability1886743_livability
miscibility2055463_miscibility
movability2077233_movability
mutability1748073_mutability
navigability2155443navigability
placability2047143placability
pliability1748053pli_ability
sociability1847923sociability
suitability1647113suitability
variability1947523vari_ability
viability1767873_vi_ability
ability12311444____ability
adaptability2055224adaptability
admissibility2183124admissibility
adoptability2054764adoptability
affectability2663854affectability
agreeability1855164agreeability
alterability1747124alterability
amiabilities16109894ami_abilities
amiably1438304ami_ab_l__y
amicable1438434amicab_l__e
amorality1446724amora__lity
animality1447804anima__lity
assignability1962874assignability
assimilability2162474assimilability
assumability1954024assumability
attainability18103984attainability
audibility1645834a_udibility
axiality1856764axi_a__lity
bankability2245244bankability
bearability1847334bearability
biddability2043844biddability
capability1947594_capability
castability1848414castability
comicality1946134comica__lity
culpability2045294culpability
curability1747864_curability
cutability1747864_cutability
damageability2253194damageability
decidability2145744decidability
deniability1748724deniability
desirability1847274desirability
drapability1986474drapability
drillability1854634drillability
drinkability2254694drinkability
driveability2155094driveability
durability1647734_durability
dyeability1945884_dyeability
edibility1546924edi__bility
electability1947054electability
eligibility1754834eligibility
equability2446744_equability
equitability2645774equitability
erasability1668934erasability
excitability2655674excitability
fishability2245284fishability
flammability2453904flam_mability
formability2146964formability
formidability2463994formidability
germinability2155064germinability
hatchability2553774hatchability
heritability2047984heritability
ignitability1856054ignitability
immiscibility2463344immiscibility
immobility1945344im_mobility
immovability2454844immovability
immutability2155894immutability
impeccability2654464impeccability
implacability2454884implacability
imputability2146384imputability
instability1649444instability
inviability1978744inviability
irritability1747484irritability
lability13710834___lability
leachability2255254leachability
liveability1945794liveability
lovability18106934_lovability
machinability2573914machinability
malleability1954844malleability
meltability1848684meltability
memorability2146444memorability
mobility1548544_m__obility
notability1549704_notability
openability1846934openability
operability1848854operability
packability2446044packability
palatability1946384palatability
palpability2046334palpability
playability2146024playability
portability1849564portability
potability1749814_potability
practicability2553324practicability
printability1946864printability
probability2047704probability
quotability2555594quotability
readability1748074readability
reliability1649464reliability
removability2255734removability
rentability16410194rentability
replicability2255604replicability
reusability1648474reusability
risibility1547544_risibility
roadability1757204roadability
salability1548524_salability
sewability1846854_sewability
solvability1946414solvability
sorbability1846374sorbability
stability14410084__stability
stainability1755684stainability
suability1448594__suability
summability2045454summability
tenability1549124_tenability
testability1648804testability
traceability1956534traceability
tractability1947094tractability
trafficability2762254trafficability
trainability1746854trainability
tunability1546984_tunability
usability1447164__usability
violability1946274violability
visibility1846484_visibility
washability2245324washability
wearability1947104wearability
wettability1946484wettability
workability2345384workability

Search took 10 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 Filter1786911488190.453394461.4
2DLD Change Limit1488191508.59617312.6
3Display Results1501500.0761973.7
 (SQL Overall)1786911509.12519582.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.