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

260 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
compactions194654(None) 
compaction1846751compaction_
coactions1349742co__actions
compacting19177092compacti_ng
compactors18256252compact_ors
companions1697262compa_nions
compassions1745772compassions
completions1746912completions
compunctions20145692compunctions
impactions1645412_impactions
coaction12310773co__action_
coaptations1547543coaptations
cofunctions1845013cofunctions
cognations1339593cogna_tions
collations12312853colla_tions
collections1547933collections
combustions1744533combustions
commotions1686843com_motions
compacters18247023compact_ers
compactible2153653compactible
compactness1953303compactness
compactor17256023compact_o_r
compacts16368903compact___s
companion1577683compa_nion_
comparisons1753973comparisons
comparting17188383comparti_ng
compassion1645983compassion_
compatriots1753543compatriots
competitions1845533competitions
compilations1848683compilations
completion1647303completion_
complexions2443623complexions
complications2147433complications
compositions1846253compositions
compulsions1744593compulsions
compunction19115903compunction_
compunctious20143033compunctious
computations1848123computations
conations111318903co_na_tions
concoctions1448253concoctions
conductions1649663conductions
confections18411393confections
connations12312943conna_tions
connections15410703connections
contractions16410403contractions
convections18411493convections
convictions1848043convictions
cooptions13107763coop__tions
copatrons1346333co_pa_trons
corrections1548863corrections
impaction1545733_impaction_
nonactions1248373no_nactions
olfactions1563873_olfactions
pactions122613503___pactions
abreactions1544194abreactions
actions94218514____actions
attractions1376404attractions
bolections14137294bo_lections
campaigns1643474campa__igns
campions143511294camp___ions
capacious1546604c_apac_ious
capacitors1643584c_apacitors
captions123813224c___aptions
carnations12311354carna_tions
carpaccios1552104carpaccio_s
caseations1258304casea_tions
cassations1276874cassa_tions
cations94524144c___a_tions
caudations13108224cauda_tions
causations1268144causa_tions
cautions103313184c___autions
cessations1256474cessa_tions
chelations1539074chela_tions
ciliations121111004cilia_tions
citations11312504c_ita_tions
clavations1546184clava_tions
coacting133412704co__acti_ng
coactors1239474co__act_ors
coalitions1247924co_alitions
coaptation1448344coaptation_
cochampions2261184cochampions
codirections1744704codirections
coeducations1745874coeducations
coenacting1545874coenacti_ng
coercions1346204co_erc_ions
cofactors1645934co_fact_ors
cofunction1745254cofunction_
cogitations1448904cogitations
cognation12310754cogna_tion_
cognitions1346044co_gnitions
coitions10312854co___itions
collation11313994colla_tion_
collection1448204collection_
collocations1646404collocations
colorations13911894colorations
comatiks16148044com_a_ti_ks
combating16310164comba_ti_ng
combatting1755144combatti_ng
combinations1897924combinations
combustion1644564combustion_
comminations18810484comminations
comminutions1894314comminutions
commissions1745264commissions
commotion1576984com_motion_
communions1656184com_munions
commutations1847264commutations
compact153712214compact____
compacted18297364compact__ed
compacter17257884compact__er
compactest1845044compact_est
compactly2043824compact__ly
companies15311804compa_ni_es
companioned1853604compa_nioned
companying2044814companyi_ng
comparatists1853734comparatists
comparatives21164854comparatives
comparators1785684comparators
comparing162410584compa_ri_ng
comparison1644354comparison_
compartment1995084compartment
compartments2094334compartments
comparts144210834compart___s
compassing1746554compassi_ng
compatible18125574compa_tible
compatibles19134144compa_tibles
compatibly21134884compa_tibly
compatriot1655964compatrio_t
compellations1954814compellations
compendious1853374compendious
compensations19136184compensations
competing163712464comp_eti_ng
competition1755774competition_
competitors1753554comp_etitors
compilation1749314compilation_
complains1549194comp_lai_ns
complecting2045764complecti_ng
completing1748424completi_ng
complexations26134014complexations
complexion2343754complexion_
complication2048204complication_
complicitous2052394complicitous
complins14313114comp__li_ns
comporting17199164comporti_ng
composition1746794composition_
compositors1754384compositors
composting17178054composti_ng
compressions1856404compressions
compting153013604comp__ti_ng
compulsion1644674compulsion_
compurgations20123894compurgations
computation1748714computation_
computing16309854comp_uti_ng
computists1644694comp_utists
conation101420884co_na_tion_
conceptions17410594conceptions
concoction1348234concoction_
concretions1549294concretions
conditions13410104co_nditions
conduction1549964conduction_
confection17411184confection_
conflations16411144conflations
conflictions1945224conflictions
congestions1449314congestions
conjunctions2345384conjunctions
connation11314264conna_tion_
connection14410534connection_
conniptions1546034conniptions
consecutions1647044consecutions
contacting15610074contacti_ng
contactors1448844contact_ors
contagions1346604conta_gions
contentions13412094contentions
contortions1348684contortions
contraction15411244contraction_
contraptions1647644contraptions
contritions13410914contritions
convection17411124convection_
conventions16410534conventions
conviction1748184conviction_
convocations1947364convocations
cooperations1659194cooperations
cooption1288344coop__tion_
copastors1346994co_past_ors
copatron1246754co_pa_tron_
copulations151111114copulations
coronations13410704coronations
corotations1349764corotations
corporations16129484corporations
corrasions1246354corra_sions
correction1448814correction_
corruptions1555174corruptions
coruscations1645244coruscations
creations112614544c_rea_tions
cremations14410714crema_tions
crenations12511694crena_tions
cumulations1547434cumulations
damnations1337084damna_tions
depictions1546894_depictions
detractions14118274detractions
dominations14611044dominations
donations101112354do_na_tions
dotations101411634do_ta_tions
exactions1838924__exactions
extractions2077744extractions
factions133013064___factions
foliations1399944folia_tions
formations1538204forma_tions
fractions1449104__fractions
gemmations1545004gemma_tions
gumptions1443774gump__tions
himations1438804him_a_tions
impacting1635944_impacti_ng
impactors15265004_impact_ors
impassions1444844_impassions
impatiens1345734_impa_tiens
impletions1445004_impletions
inactions1139324__inactions
infractions1646964infractions
inspections1546424inspections
iodations1039114io_da_tions
lobations11219614lo_ba_tions
locations112512744lo_ca_tions
morphactins2051794morphacti_ns
nominations13410534nominations
nonaction1149444no_naction_
nonfictions1645934nonfictions
notations91512974no_ta_tions
novations12139004no_va_tions
objections2145634_objections
oblations1139374_obla_tions
occupations1744544occupa_tions
olfaction1464234_olfaction_
options93810604_o_p__tions
orations81515804_o_ra_tions
ovations11149264_o_va_tions
overactions1648214overactions
paction112713964___paction_
palpations1437654palpa_tions
potations111615074po_ta_tions
proactions1449344_proactions
protractions1646644protractions
pupations1338124_pupa_tions
reactions11711714__reactions
redactions1359134_redactions
refractions16127724refractions
retractions13910354retractions
rogations101510824ro_ga_tions
rotations91613844ro_ta_tions
solations9814624so_la_tions
solvations1336834solva_tions
sonications1349954sonications
sorptions1137124sorp__tions
summations1456784summa_tions
tactions102912424___tactions
temptations1545414temptations
tompions12267004tomp___ions
tractions11511624__tractions
tumefactions1951624tumefactions
vocations141911424vo_ca_tions
zonations18139314zo_na_tions

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 Filter1786911488190.453394461.4
2DLD Change Limit1488192608.73317041.0
3Display Results2602600.1431818.2
 (SQL Overall)1786912609.32919154.4
 
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.