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 “invisiblenessesa” 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
invisiblenesses2094211invisiblenesses_
infusiblenesses2063773infusiblenesses_
invisibleness1854853invisiblene_s_s_
visiblenesses1855323__visiblenesses_
advisablenesses21113954advisablenesses_
enviablenesses1965924envi_ablenesses_
incisivenesses1966684incisi_venesses_
invasivenesses2056024invasi_venesses_
divisivenesses2154965divisi_venesses_
incapablenesses2184265incapablenesses_
ineffablenesses2364015ineffablenesses_
infinitenesses1795035infini_tenesses_
infusibleness1874365infusiblene_s_s_
initialnesses1395615in_itial_nesses_
insolublenesses1763435insolublenesses_
invidiousnesses1955015invidiousnesses_
invincibleness2173105invinciblene_s_s_
inviolatenesses1892805inviolatenesses_
irasciblenesses1962605irasciblenesses_
irritablenesses1755055irritablenesses_
nimblenesses1656015_n_i_mblenesses_
plausiblenesses1973135plausiblenesses_
sensiblenesses1555255_sensiblenesses_
visibleness1654815__visiblene_s_s_
admirablenesses2074356admirablenesses_
advisableness1954416advisablene_s_s_
amiablenesses1756536_ami_ablenesses_
amicablenesses2055216_amicablenesses_
availablenesses2063736availablenesses_
decisivenesses2056766decisi_venesses_
derisivenesses1857236derisi_venesses_
desirablenesses1855616desirablenesses_
ediblenesses1545836___ediblenesses_
enjoyablenesses2773556enjoyablenesses_
enviableness1756996envi_ablene_s_s_
equitablenesses26104356equitablenesses_
estimablenesses1954096estimablenesses_
evasivenesses1957146_evasi_venesses_
excitablenesses2664586excitablenesses_
excusablenesses2664016excusablenesses_
favorablenesses2354126favorablenesses_
forciblenesses2154196_forciblenesses_
habitablenesses2254056habitablenesses_
horriblenesses1953906_horriblenesses_
ignoblenesses1653686i__gnoblenesses_
illusivenesses1755786illusi_venesses_
immovablenesses2493806immovablenesses_
immutablenesses2164166immutablenesses_
incisiveness1756336incisi_vene_s_s_
inclusivenesses2065116inclusi_venesses_
inevitableness1985666inevitablene_s_s_
insanenesses1246876in__s_anenesses_
insatiatenesses1593486insatiatenesses_
insensibleness1684406insensiblene_s_s_
insidiousnesses1555256insidiousnesses_
intensivenesses1856286intensi_venesses_
intimatenesses1655026inti_matenesses_
intrusivenesses1885446intrusi_venesses_
intuitivenesses1865336intuiti_venesses_
invasiveness1855716invasi_vene_s_s_
invectivenesses23106016invectivenesses_
inventivenesses21136256inventivenesses_
inviolableness19104536inviolablene_s_s_
invisibles1543456invisibl_____es_
likablenesses1995446__likablenesses_
livablenesses18125846__livablenesses_
losablenesses1596076__losablenesses_
lovablenesses18115846lov__ablenesses_
movablenesses20135656mov__ablenesses_
noblenesses1348076_n___oblenesses_
noisinesses1139486_noisi___nesses_
noisomenesses1554246_nois_omenesses_
notablenesses1546656_n_otablenesses_
pitiablenesses1855066piti_ablenesses_
pliablenesses1756076_pli_ablenesses_
reliablenesses1655816reli_ablenesses_
sizablenesses2445406__sizablenesses_
sociablenesses1855126soci_ablenesses_
suitablenesses1655436_suitablenesses_
tangiblenesses1753596_tangiblenesses_
terriblenesses1694396_terriblenesses_
unstablenesses1656036un_stablenesses_
usablenesses1446746___usablenesses_
variablenesses1965496vari_ablenesses_
veritablenesses2055086veritablenesses_
vilenesses13310226__v__i_lenesses_
violablenesses1984736__violablenesses_
voidablenesses2054736_voidablenesses_
volublenesses1854566__volublenesses_

Search took 5 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.360496363.9
2DLD Change Limit65874894.50014638.7
3Display Results89890.0801112.5
 (SQL Overall)178691894.94036172.3
 
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.