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

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

111 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
emancipationist2181201emancipationist_
emancipations1953743emancipation_s__
emancipation1854174emancipation____
emaciations1548165ema_ci_ation_s__
emancipating1952895emancipati_n___g
emancipators1852515emancipat_o_rs__
annexationist20233036__annexationist_
annexationists21192576__annexationists
associationist16173356associ_ationist_
associationists17183076associ_ationists
educationist1555266e_duc__ationist_
educationists1654346e_duc__ationists
emaciation1449286ema_ci_ation____
emanations1289596eman___ation_s__
emancipates1753236emancipat___es__
emancipator1752756emancipat_o____r
emarginations1674156emargination_s__
emasculations1754606emasculation_s__
enunciations1445096enunci_ation_s__
vacationist1655906_va_c__ationist_
vacationists1754586_va_c__ationists
adoptionist1454967__a_dop_tionist_
adoptionists1553927__a_dop_tionists
animations12312197__an_imation_s__
anticipations1757497anticipation_s__
antinationalist15163527__antinationalist_
antirationalist15214427__antirationalist_
assimilationist1761797assimilationist_
associationism18172607associ_ationis_m
associationisms19192347associ_ationisms
calcinations1647937_calcination_s__
cancelations1657097_cancelation_s__
coalitionist1485507coa_li__tionist_
coalitionists1583947coa_li__tionists
colonizationist26102187colonizationist_
creationist1379237____creationist_
creationists1476627____creationists
demarcations1746127demarc__ation_s__
demolitionist1654517dem_oli__tionist_
demolitionists1763477dem_oli__tionists
demonizations25410247demon_ization_s__
denunciations1653887denunci_ation_s__
deracinations1647837dera_cination_s__
deviationist1656157__devi_ationist_
deviationists17104747__devi_ationists
ejaculations2195217eja_culation_s__
elicitations1446807e_licitation_s__
elocutionist1455097e_loc__utionist_
elocutionists1554317e_loc__utionists
elucidations1544517e_lucidation_s__
emaciating1546817ema_ci_ati_n___g
emanation11910787eman___ation____
emancipate1653547emancipa______te
emancipated1852877emancipat_____ed
emargination1554867emargination____
emasculation1655237emasculation____
embolizations2646727embolization_s__
emendations1446057emen__dation_s__
enunciation1345467enunci_ation____
eradications1549307era_dication_s__
evacuations1646307eva_c_uation_s__
evaginations1645827eva_gination_s__
examinations2167467exa_mination_s__
excitations2049007e__xcitation_s__
exercitations2254567exercitation_s__
exhibitionist2572917e__xhibitionist_
exhibitionists2662517e__xhibitionists
fasciations1646267_fasci_ation_s__
fascinations1746377_fascination_s__
feminizations2797717femin_ization_s__
germanizations26166837german_ization_s__
glaciations1445967gla_ci_ation_s__
humanizations2796637human_ization_s__
imaginations1546347ima_gination_s__
incitations13310887__incitation_s__
inflationist1555297__in_flationist_
inflationists1653847__in_flationists
laicizations2347417_laicization_s__
macerations1548477_ma_ceration_s__
machinations19115767_machination_s__
maculations1569627_ma_culation_s__
manipulations1754117_man_ipulation_s__
marginations1546457_margination_s__
marinations13411277_ma_rination_s__
mastications1649417_mastication_s__
melanizations2449367melan_ization_s__
metafictionist2191867metafi_ctionist_
metafictionists2291817metafi_ctionists
miscitations1647057_miscitation_s__
partitionist1456267_parti__tionist_
partitionists1554767_parti__tionists
quantitations2263367quantitation_s__
quantizations3164577quantization_s__
reanimations1468787rean_imation_s__
receptionist1656407__recep_tionist_
receptionists1754777__recep_tionists
recreationist1555747__recreationist_
recreationists1664377__recreationists
renunciations1554857renunci_ation_s__
repudiationist17183187repudi_ationist_
repudiationists18212637repudi_ationists
revaccinations2153617revaccination_s__
romanizations2459287roman_ization_s__
salvationist1554407_sa__lvationist_
salvationists1653567_sa__lvationists
sanitations11410847_san_itation_s__
separationist1555277sepa___rationist_
separationists1664087sepa___rationists
syncopations1952887_syncopation_s__
tetanizations2249917tetan_ization_s__
vaccinations1945687_vaccination_s__

Search took 9 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 Limit950241118.20611579.8
3Display Results1111110.0761460.5
 (SQL Overall)1786911118.40521260.1
 
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.