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

136 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
impeccabilities2584721impeccabilities_
implacabilities2354013implacabilities_
impalpabilities2363954impalpabilities_
impassabilities21155244impassabilities_
impeccability2654464impeccabilit___y
improbabilities23114294improbabilities_
improvabilities24114474improvabilities_
imputabilities2056614imp_utabilities_
affectabilities2553985affectabilities_
amenabilities1778835am_e_nabilities_
amicabilities19197895am__icabilities_
appealabilities2163885appealabilities_
applicabilities2353735applicabilities_
delectabilities2065555delectabilities_
dependabilities2155245dependabilities_
detectabilities2065825detectabilities_
electabilities1857565_electabilities_
employabilities2463125employabilities_
expendabilities2774375expendabilities_
imbecilities1853655imbe_c__ilities_
immiscibilities2363365immiscibilities_
immovabilities2355295im_movabilities_
immutabilities2056045im_mutabilities_
impassibilities21184665impassibilities_
impossibilities21174225impossibilities_
ineducabilities2054235ineducabilities_
ineffabilities2256155i_neffabilities_
insociabilities19105025insociabilities_
integrabilities1885505integrabilities_
meltabilities1749865_m_eltabilities_
openabilities1748615_ope_nabilities_
operabilities17510055_ope_rabilities_
packabilities2346555__packabilities_
placabilities1947615__placabilities_
repeatabilities1955915repeatabilities_
replicabilities2155105replicabilities_
resectabilities1956015resectabilities_
acceptabilities2354226acceptabilities_
actabilities1649986___actabilities_
agreeabilities1755346agre_eabilities_
alienabilities1656206alie_nabilities_
alterabilities1667336alte_rabilities_
amiabilities16109876am___iabilities_
bearabilities1748676__bearabilities_
capabilities1848816cap___abilities_
cleanabilities1856046_cleanabilities_
comparabilities2374376comp_arabilities_
computabilities2354536comp_utabilities_
decidabilities2046236__decidabilities_
deniabilities1649766__deniabilities_
detachabilities2354146detachabilities_
deterrabilities1875386deterrabilities_
disposabilities2053546disp_osabilities_
drapeabilities1955986drape__abilities_
dyeabilities1847866_dye__abilities_
educabilities1857066__educabilities_
equabilities2348156___equabilities_
expandabilities2763876expandabilities_
exportabilities2654566exportabilities_
extendabilities2564166extendabilities_
filterabilities2053286filte_rabilities_
hatchabilities2453996_hatchabilities_
hypermobilities2763426hypermobilities_
ignitabilities17106306i_gnitabilities_
illegibilities1754406ille_gibilities_
immobilities1846266im___mobilities_
impeccable2044526impeccab_l___e__
impecuniosities219926impecuniosities_
impersonalities1963676impersonalities_
implacability2454866implacabilit___y
inabilities13412736i____nabilities_
incapabilities2056206i_ncapabilities_
indelibilities1755556inde_libilities_
inducibilities1975136i_nducibilities_
inevitabilities2055646inevitabilities_
inexorabilities2454676inexorabilities_
infeasibilities2064716infeasibilities_
insatiabilities1775506insatiabilities_
insensibilities1764906insensibilities_
instabilities1549846i__nstabilities_
insurabilities1676896i_nsurabilities_
invariabilities2055126invariabilities_
inviabilities1848816i__nviabilities_
invincibilities2293726invincibilities_
inviolabilities2064316inviolabilities_
irascibilities1854816i_rascibilities_
irritabilities1647296i_rritabilities_
leachabilities2155536_leachabilities_
liveabilities1846756live__abilities_
mailabilities1767696_m_ailabilities_
malleabilities1874976_malleabilities_
memorabilities20137006_memorabilities_
miscibilities1955696_m_iscibilities_
modulabilities1954196_modulabilities_
movabilities1978366_m__ovabilities_
mutabilities1649536_m__utabilities_
observabilities2293746observabilities_
opposabilities2054906_opposabilities_
palpabilities1947246__palpabilities_
patentabilities1995336patentabilities_
penetrabilities1965326penetrabilities_
permeabilities2056826__permeabilities_
playabilities2046606__playabilities_
pliabilities1649386__p_liabilities_
portabilities17410186__portabilities_
potabilities16411296__p_otabilities_
pregnabilities1956546_pregnabilities_
probabilities1958076__probabilities_
readabilities1649306__readabilities_
reliabilities15410446__reliabilities_
remediabilities2054616remediabilities_
renewabilities1956206rene_wabilities_
rentabilities15411236__rentabilities_
repairabilities1955366repairabilities_
reputabilities1847426rep_utabilities_
reusabilities1549266__reusabilities_
separabilities1847346sep_arabilities_
severabilities1947436seve_rabilities_
sewabilities1748936__se_wabilities_
sinterabilities17114616sinte_rabilities_
sociabilities1748386__sociabilities_
specialities1656776_specia__lities_
spreadabilities2054006spreadabilities_
squeezabilities3562306squeezabilities_
tenabilities14911486__te_nabilities_
testabilities1549936__testabilities_
tolerabilities16116606tole_rabilities_
traceabilities1855866_traceabilities_
tractabilities1846586_tractabilities_
treatabilities1657606_treatabilities_
unreliabilities1754786unreliabilities_
unsociabilities19113996unsociabilities_
untenabilities1656996unte_nabilities_
venerabilities1967356vene_rabilities_
wearabilities1848416__wearabilities_
wettabilities1847776__wettabilities_

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.0931921408.6
2DLD Change Limit658741365.53011912.1
3Display Results1361360.1261079.4
 (SQL Overall)1786911365.74931082.1
 
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.