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

172 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
excerptions224498(None) 
exceptions2146861exce_ptions
excerption2145061excerption_
exception2046852exce_ption_
excerpting2244142excerpti_ng
excerptors2163462excerpt_ors
excretions1946622exc_retions
execrations2048922execrations
exemptions2164832ex_emptions
exertions1639762ex_er_tions
exsertions1746742exser_tions
deceptions1547863dece_ptions
encryptions1852963encryptions
exacerbations2452503exacerbations
excavations2345083excavations
excepting2145873exce_pti_ng
exceptional2254443exce_ptional
excerpters2143183excerpt_ers
excerptor2063653excerpt_o_r
excerpts1943743excerpt___s
excitations2049003excitations
excoriations2147523excoriations
excretion1846713exc_retion_
exculpations2344173exculpations
excursions1944323excur_sions
execration1949833execration_
executions1946393ex_ecutions
exemption2064943ex_emption_
exertion15310083ex_er_tion_
exonerations1947013exonerations
expeditions2144633expeditions
expirations2069583expirations
exsections1947633exse_ctions
exsertion1646853exser_tion_
extirpations2174283extirpations
extortions1746473extor_tions
inceptions1448533ince_ptions
lacerations1348333lacerations
macerations1548473macerations
perceptions1798193perce_ptions
receptions1449743rece_ptions
ulcerations1346363ulcerations
absorptions1544594absorptions
accretions1444924_accretions
ademptions1543384_ademptions
adsorptions1444164adsorptions
aerations9317904__aerations
alterations11511664alterations
ascriptions1544984ascriptions
assertions1046584asser_tions
captions123813224__c_aptions
ceratins102818734__cerati_ns
conceptions17410594conce_ptions
cooptions13107764__cooptions
creations112614544__creations
deaerations12311674deaerations
deception1448324dece_ption_
decorations14312884decorations
decryptions1943614decryptions
descriptions1755404descriptions
desecrations1559214desecrations
desertions1139884deser_tions
desorptions1445994desorptions
desperations1559524desperations
deuterations1348084deuterations
egestions1046704e_ge_stions
ejections18249964e_je_ctions
elections112414974e_le_ctions
elevations1338634e_levations
emersions1147284e_mer_sions
emigrations14187154emigrations
encryption1753124encryption_
enervations1478574e_nervations
enumerations14135514enumerations
erections112515214e_re_ctions
eruptions1146764e__ruptions
escalations1347664escalations
evections142510694e_ve_ctions
eversions1238364e_ver_sions
eviscerations1882704eviscerations
exacerbation2352954exacerbation_
exactions1838924ex__actions
exaggerations2253484exaggerations
exaltations1847294exaltations
exasperations2253694exasperations
excavation2245434excavation_
excelsiors1952034exce_lsiors
exceptive2345684exce_pti_ve
excepts1885204exce_pt___s
excerpt1845944excerpt____
excerpted2153874excerpt__ed
excerpter2063904excerpt__er
excisions1846384exc__isions
excitation19410174excitation_
excitons1746044exc__it_ons
exclamations23104104exclamations
exclusions1945014exc_lusions
excoriation2048434excoriation_
excreting1946434exc_reti_ng
exculpation2244874exculpation_
excursion1844614excur_sion_
execrating2047884execrati_ng
execrators1946024execrat_ors
execution1846304ex_ecution_
exempting2144224ex_empti_ng
exenterations2054484exenterations
exerting162211154ex_er_ti_ng
exhalations2146024exhalations
exhaustions2153124exhaustions
exhibitions2353654exhibitions
exhortations2244454exhortations
exhumations2344084exhumations
exoneration1847654exoneration_
expectations2365844expectations
expedition2044904expedition_
expeditious2152534expeditious
experting1938054exper_ti_ng
expertises1947104exper_tises
expertisms21114494exper_tisms
expertizes28106014exper_tizes
expiations1959664ex_piations
expiration19610714expiration_
explorations2185614explorations
exportations2146654exportations
expositions2046844expositions
expressions2086364expressions
expunctions2243634expunctions
expurgations2274124expurgations
exsection1847494exse_ction_
exserting1736664exser_ti_ng
exsolutions1844014exsolutions
extensions1746134exte_nsions
extenuations1945084extenuations
exteriors1647324exter__iors
extinctions2044634extinctions
extirpation2084924extirpation_
extortion1646724extor_tion_
extractions2077744extractions
extrusions1745164ex_trusions
exudations18107074ex_udations
exultations1846524exultations
exuviations2195694exuviations
federations1548884federations
generations12311424generations
inception1348694ince_ption_
incretions1248654inc_retions
insertions10410344inser_tions
iterations10413824_iterations
laceration1249574laceration_
liberations1358944liberations
literations11610584literations
maceration1449614maceration_
mercurations1646564mercurations
moderations1448274moderations
numerations13127294numerations
operations12312954_operations
perception1688614perce_ption_
preemptions17134854preemptions
preoptions1447644_preoptions
reception13410324rece_ption_
recreations13412254recreations
redemptions1643734redemptions
reiterations12410874reiterations
reoperations14410064reoperations
resorptions1347234resorptions
scorpions1344214_scorp_ions
secretions12117854sec_retions
sorptions1137124__sorptions
subreptions1545884subreptions
tolerations1158134tolerations
ulceration1247264ulceration_
venerations14411314venerations

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191728.28017973.3
3Display Results1721720.0931849.5
 (SQL Overall)1786911728.79620315.0
 
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.