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

89 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
impassibilities21184661impassibilities_
impassabilities21155242impassabilities_
impossibilities21174222impossibilities_
expansibilities2693384expansibilities_
immiscibilities2363364immiscibilities_
impalpabilities2363954impalpabilities_
impassibility2254634impassibilit___y
impassivities2062954impass__ivities_
irascibilities1854814i_rascibilities_
possibilities1756054__possibilities_
accessibilities2162975accessibilities_
admissibilities2063275admissibilities_
compatibilities2363605compa_tibilities_
feasibilities1866565_fea_sibilities_
impartialities1863495imparti_alities_
impassability2265235impassabilit___y
impeccabilities2584725impeccabilities_
implacabilities2354015implacabilities_
impossibility2254195impossibilit___y
improbabilities23114295improbabilities_
improvabilities24114475improvabilities_
imputabilities2056615imp_utabilities_
inaudibilities1754955i_naudibilities_
infallibilities2063605infallibilities_
infeasibilities2064715infeasibilities_
infusibilities1955455i_nfusibilities_
insensibilities1764905insensibilities_
intangibilities1864475intangibilities_
invisibilities1956115i_nvisibilities_
miscibilities1955695_m_iscibilities_
partibilities1748095__partibilities_
plausibilities1873755_plausibilities_
amiabilities16109876amia___bilities_
audibilities1546636___audibilities_
capabilities1848816capa___bilities_
castabilities1748796__castabilities_
classicalities1862536_classicalities_
comparabilities2374376compa_rabilities_
crossabilities1855686_crossabilities_
defeasibilities2153816defeasibilities_
defensibilities2164046defensibilities_
digestibilities1963286digestibilities_
disposabilities2053546disp_osabilities_
divisibilities2064056_divisibilities_
employabilities2463126employabilities_
erasabilities1549606_era_sabilities_
expandabilities2763876expandabilities_
extensibilities2493466extensibilities_
fallibilities1854546__fallibilities_
frangibilities2054036_frangibilities_
fusibilities1746226___fusibilities_
illegibilities1754406i_llegibilities_
immobilities1846266im___mobilities_
immovabilities2355296im_movabilities_
immutabilities2056046im_mutabilities_
impassableness2063236impassab_l_eness
impassible1655206impassib_l___e__
impersonalities1963676impersonalities_
implausibility2362896implausibilit___y
impossibleness2062256impossib_l_eness
impressibility2364366impressibilit___y
impulsivities2062016impuls__ivities_
inabilities13412736i_na___bilities_
incapabilities2056206inca_pabilities_
incredibilities20113666incredibilities_
indelibilities1755556i_ndelibilities_
inducibilities1975136i_nducibilities_
ineligibilities1864096ineligibilities_
inflexibilities2763246inflexibilities_
insatiabilities1775506insatiabilities_
instabilities1549846i__nstabilities_
invariabilities2055126invariabilities_
invincibilities2293726invincibilities_
mailabilities1767696_m_ailabilities_
measurabilities1964226_measurabilities_
metastabilities1955496metastabilities_
opposabilities2054906_opposabilities_
packabilities2346556__packabilities_
palpabilities1947246__palpabilities_
passivities1644906__pass__ivities_
repairabilities1955366repairabilities_
resistibilities1753976resistibilities_
reversibilities2084156reversibilities_
risibilities1448626___risibilities_
sensibilities1557366__sensibilities_
separabilities1847346sepa_rabilities_
tangibilities1655486__tangibilities_
visibilities1747376___visibilities_
washabilities2145986__washabilities_

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 Filter178691658740.0931921408.6
2DLD Change Limit65874896.9709451.1
3Display Results89890.0761171.1
 (SQL Overall)178691897.13925030.3
 
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.