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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
excludabilities27102411excludabilities_
extrudabilities2552983extrudabilities_
excitabilities2556314exc_itabilities_
excludability2852694excludabilit___y
expandabilities2763874expandabilities_
expendabilities2774374expendabilities_
extendabilities2564164extendabilities_
culpabilities1946005__culpabilities_
curabilities1649385__c_urabilities_
cutabilities1649115__c_utabilities_
decidabilities2046235dec_idabilities_
educabilities1857065e__ducabilities_
employabilities2463125employabilities_
equabilities2348155e__qu_abilities_
exclusivities2561995exclu__sivities_
exportabilities2654565exportabilities_
acceptabilities2354226acceptabilities_
actabilities1649986_ac__tabilities_
affordabilities2453056affordabilities_
analyzabilities2952716analyzabilities_
applicabilities2353736applicabilities_
assumabilities1853976_assumabilities_
audibilities1546636___audibilities_
biddabilities1944986__biddabilities_
capabilities1848816__c_apabilities_
castabilities1748796__castabilities_
cleanabilities1856046__cleanabilities_
coagulabilities2062726coagulabilities_
coilabilities1748076__coilabilities_
computabilities2354536computabilities_
countabilities1856666__countabilities_
credibilities1856066__credibilities_
dependabilities2155246dependabilities_
dilatabilities1795936_dilatabilities_
drillabilities1754786dril_labilities_
durabilities1549336___durabilities_
edibilities1458706e____dibilities_
electabilities1857566e_lectabilities_
eligibilities1655646e__ligibilities_
enumerabilities1954066enumerabilities_
equitabilities2566016e_quitabilities_
erasabilities1549606e__rasabilities_
erodibilities1656886e__rodibilities_
excludable2252546excludab_l___e__
expansibilities2693386expansibilities_
extensibilities2493466extensibilities_
extrudability2673136extrudabilit___y
formidabilities2353376formidabilities_
immutabilities2056046_immutabilities_
implacabilities2354016implacabilities_
imputabilities2056616_imputabilities_
inaudibilities1754956_inaudibilities_
incapabilities2056206inc_apabilities_
incredibilities20113666incredibilities_
ineducabilities2054236ineducabilities_
insurabilities1676896_insurabilities_
labilities12712236___l__abilities_
leachabilities2155536leac__habilities_
liabilities13710256___l_iabilities_
likabilities1877276___likabilities_
livabilities1767716___livabilities_
lovabilities1788006___lovabilities_
machinabilities2473086machinabilities_
mailabilities1767696mail__abilities_
malleabilities1874976_malleabilities_
measurabilities1964226measurabilities_
meltabilities1749866_mel_tabilities_
mensurabilities1964416mensurabilities_
modulabilities1954196_modulabilities_
mutabilities1649536___mutabilities_
packabilities2346556pac__kabilities_
palatabilities1846786_palatabilities_
palpabilities1947246_pal_pabilities_
perdurabilities2074436perdurabilities_
placabilities1947616__placabilities_
playabilities2046606__playabilities_
pliabilities1649386__pl_iabilities_
readabilities1649306__readabilities_
recallabilities1963956recallabilities_
refundabilities2153926refundabilities_
reliabilities15410446_rel_iabilities_
replicabilities2155106replicabilities_
reputabilities1847426_reputabilities_
reusabilities1549266__reusabilities_
roadabilities1647796__roadabilities_
salabilities1449606_sal__abilities_
sociabilities1748386soc__iabilities_
solubilities1446006_solu__bilities_
solvabilities1846896_sol_vabilities_
spreadabilities2054006spreadabilities_
suabilities13610786___su_abilities_
tolerabilities16116606_tolerabilities_
tunabilities14138726___tunabilities_
upgradabilities2162466upgradabilities_
usabilities1368986____usabilities_
violabilities1856816viol__abilities_
volubilities1745126_volu__bilities_

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 Filter178691658740.0961861364.6
2DLD Change Limit65874975.26312516.4
3Display Results97970.0801212.5
 (SQL Overall)178691975.43932853.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.