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

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

100 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
employabilities246312(None) 
employability2553043employabilit__y
implacabilities2354013implacabilities
improbabilities23114293improbabilities
improvabilities24114473improvabilities
playabilities2046603__playabilities
applicabilities2353734applicabilities
employables2051634employab_l___es
excludabilities27102414excludabilities
expandabilities2763874expandabilities
expendabilities2774374expendabilities
exportabilities2654564exportabilities
immovabilities2355294im_movabilities
impalpabilities2363954impalpabilities
impassabilities21155244impassabilities
impeccabilities2584724impeccabilities
imputabilities2056614imp_utabilities
lovabilities1788004___lovabilities
malleabilities1874974_malleabilities
meltabilities1749864_mel_tabilities
memorabilities20137004_memorabilities
movabilities1978364_m__ovabilities
opposabilities2054904_opposabilities
placabilities1947614__placabilities
pliabilities1649384__pl_iabilities
potabilities16411294__p_otabilities
probabilities1958074__probabilities
removabilities2186314rem__ovabilities
replicabilities2155104replicabilities
adorabilities1647805__adorabilities
amenabilities1778835am__enabilities
amiabilities16109875am___iabilities
amicabilities19197895am__icabilities
analyzabilities2952715analyzabilities
appealabilities2163885appealabilities
capabilities1848815cap___abilities
coilabilities1748075coil__abilities
comparabilities2374375comp_arabilities
computabilities2354535comp_utabilities
culpabilities1946005_cul_pabilities
dependabilities2155245dependabilities
detonabilities1756705_detonabilities
dilatabilities1795935_dilatabilities
disposabilities2053545disposabilities
drillabilities1754785dril_labilities
educabilities1857065e__ducabilities
electabilities1857565e_lectabilities
eligibilities1655645e__ligibilities
employable1943155employab_l___e_
enumerabilities1954065enumerabilities
equabilities2348155e___quabilities
equitabilities2566015e_quitabilities
erasabilities1549605e__rasabilities
erodibilities1656885e__rodibilities
excitabilities2556315e_xcitabilities
expansibilities2693385expansibilities
extendabilities2564165extendabilities
extrudabilities2552985extrudabilities
honorabilities1955945_honorabilities
immobilities1846265im_mo__bilities
immutabilities2056045im_mutabilities
impassibilities21184665impassibilities
impossibilities21174225impossibilities
inexorabilities2454675inexorabilities
inviolabilities2064315inviolabilities
labilities12712235___l__abilities
liabilities13710255___l_iabilities
likabilities1877275___likabilities
livabilities1767715___livabilities
mailabilities1767695_m_ailabilities
measurabilities1964225measurabilities
mensurabilities1964415mensurabilities
metastabilities1955495metastabilities
mobilities1449835_m__o__bilities
modulabilities1954195_modulabilities
mutabilities1649535_m__utabilities
notabilities14410715___notabilities
openabilities1748615_op_enabilities
operabilities17510055_op_erabilities
packabilities2346555__packabilities
palatabilities1846785_palatabilities
palpabilities1947245__palpabilities
portabilities17410185__portabilities
promotabilities2184525promotabilities
quotabilities2466625__quotabilities
reasonabilities1754665reasonabilities
recallabilities1963955recal_labilities
reliabilities15410445_rel_iabilities
remediabilities2054615rem_ediabilities
repairabilities1955365repairabilities
repeatabilities1955915repeatabilities
reputabilities1847425rep_utabilities
salabilities1449605_sal__abilities
separabilities1847345sep_arabilities
solvabilities1846895_sol_vabilities
temporalities1753485temp_ora__lities
tolerabilities16116605_tolerabilities
unemployability2771465unemployabilit__y
unknowabilities2492095unknowabilities
violabilities1856815__violabilities

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.1401276364.3
2DLD Change Limit658741004.83013638.5
3Display Results1001000.0761315.8
 (SQL Overall)1786911005.04635412.4
 
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.