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

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

134 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
hallucinations1911252(None) 
hallucination18122831hallucination_
hallucinating1952332hallucinati_ng
hallucinators1861832hallucinat_ors
calcinations1647933ca_l_cinations
gallicizations2673903gallicizations
hallucinates1752733hallucinat__es
hallucinator1772053hallucinat_o_r
hallucinatory2161453hallucinat_ory
illuminations1554443_illuminations
agglutinations16102514agglutinations
alleviations1554494_allevi_ations
allocations1347774_alloc__ations
calcination1548904ca_l_cination_
calumniations1763484ca_lumniations
elucidations1544514__elucidations
fascinations1746354fa__scinations
gallicization2574034gallicization_
hallucinate1653004hallucinat___e
hallucinated1852544hallucinat__ed
hallucinogens1961544hallucin_ogens
hallucinosis1761584hallucinosi__s
halogenations1772914ha_logenations
hellenizations2654324hellenizations
illumination1455164_illumination_
illuviations1553054_illuvi_ations
palletizations25105004palletizations
palliations1347724pall__i_ations
pollinations1447234poll__inations
ratiocinations1674134ratiocinations
vaccinations1945674va__ccinations
vaticinations1845024va_ticinations
abominations1646605_a_bominations
adjudications2452325_adjudications
agglutination15112655agglutination_
aldolizations2346335_aldolizations
alienations1147875_a_l_ienations
allegations1246045_all__egations
alleviation1454655_allevi_ation_
alliterations1384545_alliterations
allocation1248575_alloc__ation_
allocutions1353985_alloc__utions
alternations1246775_a_lternations
anglicizations26123335anglicizations
annunciations1572655_annunci_ations
anticipations1757485_anticipations
associations1445745_associ_ations
balkanizations2963985balkanizations
calcifications2045415calcifications
calculations1647075ca_l_culations
calumniation1663995ca_lumniation_
capacitations1953625ca_pacitations
carburizations2754125carburizations
chlorinations1855505_chlorinations
claudications1852885_claudications
colligations1556835coll__igations
collimations1656875coll__imations
collocations1646395colloc__ations
columniations1764785_columniations
conglutinations1862545conglutinations
culminations1646535_cul_minations
declinations15410215decl__inations
deglaciations1753915deglaci_ations
delaminations1647935_delaminations
deracinations1647815_deracinations
elicitations1446805__elicitations
eliminations1447605__eliminations
elucidation1445015__elucidation_
eluviations14115795__eluvi_ations
excruciations24112985excruci_ations
falsifications2244975falsifications
fasciations1646265fa__sci_ations
fascination1646785fa__scination_
felicitations1874585_felicitations
fluctuations1752565__fluctuations
fluorinations16103955_fluorinations
fulminations1745035_ful_minations
galvanizations27224455galvanizations
glaciations1445965__glaci_ations
habilitations1884865ha_bilitations
habitations1646885ha___bitations
halations12312395ha_l____ations
hallucinogen1861635hallucin_ogen_
hallucinoses1761745hallucin__oses
halogenation1683185ha_logenation_
harmonizations28124835harmonizations
haruspications2151625haruspications
hellenization2554195hellenization_
illuminating1553925_illuminati_ng
illuminators1453275_illuminat_ors
illustrations1353155_illustrations
illuviation1453575_illuvi_ation_
inclinations1448745incl__inations
italicizations2553805italicizations
jollifications26144595jollifications
laciniations1445915___laciniations
laicizations2347415__laicizations
lallations1038745lall____ations
laminations1339795___laminations
lunations9310725___lu__nations
machinations19115765ma__chinations
malfunctions1952665malfu__nctions
marginations1546455ma__rginations
marinations13411265ma___rinations
mollifications21145205mollifications
nullifications1954305nullifications
paginations1447755pa___ginations
palletization2495185palletization_
palliation1248505pall__i_ation_
palpitations1645525pa_l_pitations
participations2054525participations
patinations13411005pa___tinations
pelletizations25105025pelletizations
pollination1348015poll__ination_
pullulations1442965pullu__lations
ratiocination1574325ratiocination_
reallocations1553805realloc__ations
reluctations1446755_reluc_tations
revaccinations2153615revaccinations
ruinations1039605___ru_inations
ruminations1349395___ruminations
salinizations2258425sa_linizations
salivations1448735sa_l__ivations
salutations1147645sa_lu__tations
solicitations1544885_solicitations
supinations1348825___supinations
syllabications2152015syllabications
urinations10310685____urinations
vaccination1846455va__ccination_
validations1547245va_l__idations
vallations1339085vall____ations
valorizations2597775va_lorizations
valuations1348785va_lu___ations
vaticination1745755va_ticination_

Search took 10 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.1401276364.3
2DLD Change Limit950241348.97010593.5
3Display Results1341340.0931440.9
 (SQL Overall)1786911349.20319416.6
 
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.