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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
inactivations185424(None) 
inactivation1745091inactivation_
activations1669262__activations
deactivations19175062deactivations
inactivating1853462inactivati_ng
reactivations18176142reactivations
activation15610133__activation_
captivations1945343_captivations
deactivation18156083deactivation_
inactivates1645043inactivat__es
inactivities1755583inactiviti_es
incitations13310873in_c_itations
inclinations1448743in_clinations
incurvations1746383in_curvations
initiations11410723in_iti_ations
instigations1348243in_stigations
intimations13411883in__timations
jactitations2145013_jactitations
reactivation17176953reactivation_
activating1647854__activati_ng
activators1545944__activat_ors
actuations1239294__act_uations
aestivations1547484_aestivations
brachiations19193524brachi_ations
captivation1846174_captivation_
castigations1547204_castigations
coacervations2053864coacervations
cultivations1745594_cultivations
deactivating1953454deactivati_ng
deactivators1852574deactivat_ors
emaciations1548154emac_i_ations
estivations1449274__estivations
finalizations2549254fina_lizations
fractionations1952854fractionations
glaciations1445964glac_i_ations
imaginations1546334ima_ginations
inactions1139324inac____tions
inactivate1545694inactivat___e
inactivated1744554inactivat__ed
inanitions1046384ina_ni__tions
inattentions1252604ina_ttentions
inaugurations1453154inaugurations
incantations1446634in_cantations
incardinations1754414incardinations
incarnations1446664in_carnations
incitation12312224in_c_itation_
inclination1349734in_clination_
incubations1547304in_c_ubations
inculcations1666314in_culcations
inculpations1675954in_culpations
incurvation1646984in_curvation_
indications14310974in__dications
indoctrinations1872314indoctrinations
inebriations1456324inebri_ations
infatuations1544434infat_uations
infixations2146694in__fixations
infuriations1547444infuri_ations
ingratiations1455154ingrati_ations
inhabitations1853724inhabitations
initiation10412104in_iti_ation_
innervations1546924in_nervations
innovations1445264in__novations
inoculations1457684inoc_ulations
insanitations13136464insanitations
inscriptions1654504inscri_ptions
inseminations1546224inseminations
inspirations1447294in_spirations
instantiations1493514instanti_ations
instigation1249244in_stigation_
instillations1344924in_stillations
institutions1244734in_stitutions
intimation12413034in__timation_
intimidations1686664intimidations
intinctions1347004in__tinctions
intonations1149524in__tonations
intoxications22135674intoxications
intubations1346834in__tubations
invaginations1755084invaginations
invalidations1745614invalidations
investigations1853724investigations
invigilations1764484invigilations
invitations1449044in__vitations
jactations1936894_jact__ations
jactitation2045624_jactitation_
lacrimations1645704_lacrimations
lactations1239424_lact__ations
machinations19115764_machinations
mastications1649414_mastications
motivations1647094__motivations
natations91412494_na_t__ations
navigations1545204_na_vigations
nictations1278314_nict__ations
passivations1764434_passivations
patinations13411004_pa_tinations
pectinations1649254_pectinations
quantitations2263364quantitations
quantizations3164574quantizations
reactivating1844754reactivati_ng
remotivations1846684remotivations
salivations1448734_sa_livations
sanitizations2248544sanitizations
satiations10312094_sa_ti_ations
titivations1446264__titivations
unitizations2147454un_itizations
vaccinations1945674_vaccinations

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 Filter178691950240.1231452772.4
2DLD Change Limit950241055.57617041.6
3Display Results1051050.0631666.7
 (SQL Overall)1786911055.76231012.0
 
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.