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

334 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
convections1841149(None) 
confections18411391confections
connections15410701connections
convection17411121convection_
conventions16410531conventions
convictions1848041convictions
collections1547932collections
conceptions17410592conceptions
concoctions1448252concoctions
conductions1649662conductions
confection17411182confection_
congestions1449312congestions
connection14410532connection_
consecutions1647052consecutions
contentions13412092contentions
convecting18310432convecti_ng
convectional1947042convectional
convectors1768312convect_ors
convention15410562convention_
conversions1648272conversions
conviction1748182conviction_
convocations1947362convocations
corrections1548862corrections
advections1645553_advections
bolections14137293bo_lections
coactions1349743co__actions
codirections1744703codirections
cofunctions1845013cofunctions
collection1448203collection_
compactions1946543compactions
conations111318903con__ations
conception16410453conception_
concertinos15158123concertinos
concessions15128103concessions
concoction1348233concoction_
concretions1549293concretions
conditions13410103con_ditions
conduction1549963conduction_
confecting18310553confecti_ng
confectioner1964143confectioner
confectioners2073373confectioners
confessions16136633confessions
conflations16411143conflations
conflictions1945223conflictions
congelations1549733congelations
congestion1349043congestion_
conjunctions2345383conjunctions
connations12312943con_nations
connecting15310383connecti_ng
connectional1646723connectional
connectives1847503connectives
connectors1448183connect_ors
connexions1974623conne_xions
conniptions1546033conniptions
consecrations1749213consecrations
consecution1547313consecution_
contention12412223contention_
contentious1347013contentious
contortions1348683contortions
contractions16410403contractions
contritions13410913contritions
convective2049113convecti_ve
convector1648083convect_o_r
convects153410993convect___s
conventing16311543conventi_ng
conventional1757163conventional
conversations1847453conversations
conversion1548423conversion_
converting16313133converti_ng
convertors1549133convert_ors
convicting1847583convicti_ng
convocation1847883convocation_
convolutions1745193convolutions
convulsions1644313convulsions
correction1448813correction_
evections142510693__evections
infections15510233_infections
injections1948663_injections
inventions1348313_inventions
nonactions1248373non_actions
nonelections1456393nonelections
nonfictions1645933nonfictions
nonvectors1556283nonvect_ors
objections2145633_objections
reconnections1765753reconnections
reconvictions2054873reconvictions
abjections2145674_abjections
advection1545554_advection_
affections1845894_affections
bijections21134934_bijections
bilections14136504_bilections
bisections14136734_bisections
bolection13117674bo_lection_
cancelations1657094cancelations
caseations1258304c_aseations
clavations1546184clav_ations
coaction12310774co__action_
coalitions1247924co_alitions
coaptations1547544coaptations
codirection1644744codirection_
coeducations1745874coeducations
coercions1346204co__ercions
coerecting15218784coerecti_ng
coevolutions1754084coevolutions
cofunction1745254cofunction_
cogitations1448904cogitations
cognations1339594co_gnations
cognitions1346044co_gnitions
cohesions1447094co_he_sions
coinfecting1944574coinfecti_ng
coinventing1744544coinventi_ng
coinventors1652944coinvent_ors
coinvestors1672874coinvest_ors
coitions10312854co___itions
collations12312854co_llations
collecting1548284collecti_ng
collectives1846034collectives
collectors1446594collect_ors
collocations1646404collocations
colorations13911894colorations
combustions1744534combustions
commotions1686844co_mmotions
compaction1846754compaction_
competitions1845534competitions
completions1746914completions
compunctions20145694compunctions
conation101420884con__ation_
conceiting15311774conceiti_ng
conceptional1856914conceptional
concertina14410614concerti_na
concertinas15107554concertinas
concerting15313894concerti_ng
concertino14910844concerti_no
concertizes24158584concertizes
concertos132711134concert_o_s
concession14148134concession_
concisions1448244con_cisions
conclusions1544884conclusions
concocting1448414concocti_ng
concoctors1346404concoct_ors
concretion1449294concretion_
concussions15125324concussions
condemnations1845404condemnations
condensations1646274condensations
condition12411164con_dition_
condonations1548004condonations
conducting1648834conducti_ng
conductors1546974conduct_ors
confectionary2353774confectionary
confectionery2362564confectionery
confects153110874confect___s
confession15126504confession_
confiscations2044954confiscations
conflation15412084conflation_
confliction1845234confliction_
confusions1546304con_fusions
confutations1767794confutations
congelation14410344congelation_
congesting14410114congesti_ng
congregations17186414congregations
conjectures22134894conjectures
conjugations2245864conjugations
conjunction2245624conjunction_
conjurations2148494conjurations
connation11314264con_nation_
connecters1448014connect_ers
connectible1755254connectible
connective1749254connecti_ve
connector1347924connect_o_r
connects123010564connect___s
connexion1874604conne_xion_
conniption1446274conniption_
connotations1447284connotations
conscious1347594con_sc_ious
consecration1649784consecration_
consenting13313224consenti_ng
conservations1849094conservations
consociations1747514consociations
consolations1449744consolations
constrictions1747784constrictions
constructions1747714constructions
consumptions1845144consumptions
contacting15610074contacti_ng
contactors1448844contact_ors
contagions1346604con_tagions
contenting13313324contenti_ng
contestations1547734contestations
contesting13312214contesti_ng
contortion1248664contortion_
contraction15411244contraction_
contraptions1647644contraptions
contraventions19103574contraventions
contrition12411414contrition_
contusions1246994con_tusions
conurbations1646664conurbations
convect143114484convect____
convected1738784convect__ed
convenient1549054conve_nient
convening15311194conve_ni_ng
convenors14277634conve__nors
conventicle1854714conventicle
conventicles1954164conventicles
conventioneer18152624conventioneer
conventioneers1982394conventioneers
convents132614604convent___s
conventuals1665174conventuals
converging1758094convergi_ng
conversation1747804conversation_
conversing16310544conversi_ng
conversional1755144conversional
conversos1446894conve_rso_s
converters1539634convert_ers
convertible1846234convertible
convertibles1954624convertibles
convertibly2155134convertibly
convertor1448784convert_o_r
converts133213554convert___s
convexities2354564convexities
conveying1838324conve_yi_ng
conveyors17235524conve__yors
convicts15337714convict___s
convocational2054474convocational
convolution1645124convolution_
convulsion1544434convulsion_
cooperations1659194cooperations
cooptions13107764co__options
copulations151111114copulations
coronations13410704coronations
corotations1349764corotations
correcting15199304correcti_ng
correctional1675324correctional
correctives1845574correctives
correctors1447494correct_ors
correlations1447864correlations
corruptions1555174corruptions
coruscations1645244coruscations
counteractions1855024counteractions
counterions1349824counte_rions
coveting141912304co_ve_ti_ng
covetous1347094co_ve_t_ous
creations112614544c__reations
cunctations1576154cunctations
decongestions1753564decongestions
defections161510204_defections
deflections17187324deflections
dejections20168354_dejections
detections131410044_detections
directions1379644_directions
disconnections1954024disconnections
dissections14198264dissections
donations101112354don__ations
ejections18249964__ejections
elections112414974__elections
erections112515214__erections
evection131910834__evection_
evictions14228624__evictions
exsections1947634_exsections
flections14239214__flections
functions1437744fun__ctions
inactions1139324_in_actions
inceptions1448534_inceptions
indentions1149064_indentions
indictions1339314_indictions
inductions1348804_inductions
infection14410474_infection_
infectious1545604_infectious
inflections1646994inflections
ingestions1197594_ingestions
injection1838654_injection_
insertions10410344_insertions
inspections1546424inspections
intentions10411404_intentions
inunctions1246754_inunctions
invectives1885904_invectives
invention1248334_invention_
inversions1347004_inversions
invertins12911024_inverti_ns
invocations1647064_invocations
ionizations2049894ionizations
junctions1835944jun__ctions
lections102413844___lections
lineations1039544lin_eations
midsections1644404midsections
misconnections2063814misconnections
monecious1376344mon_ec_ious
monitions11310884mon__itions
monoecious1444774monoec_ious
nonaction1149444non_action_
nonconnections1894144nonconnections
nondecisions1553514nondecisions
nonelection1347204nonelection_
nonfiction1546304nonfiction_
nonvector1445794nonvect_o_r
novations12139004no_v_ations
objection2045094_objection_
obversions1544514_obversions
obviations1545464_obviations
olfactions1563874_olfactions
ovations11149264_o_v_ations
overactions1648214_o_veractions
perfections1848144perfections
preconvictions2353354preconvictions
prelections151210474prelections
preventions1648534preventions
projections2258474projections
protections15510704protections
recollections1754724recollections
reconceptions1965124reconceptions
reconnection1655994reconnection_
reconversions1853864reconversions
reconviction1955084reconviction_
reelections13167944reelections
refections151811644_refections
reflections16178554reflections
reinfections1745324reinfections
reinjections2144404reinjections
reinventions1554214reinventions
rejections191510104_rejections
resections121513034_resections
sanctions1138874san__ctions
sections102714704___sections
selections12310874_selections
solvations1336834solv_ations
sonications1349954sonications
subjections2296354subjections
subsections1597104subsections
subventions1674844subventions
surjections2075284surjections
trajections2044514trajections
transections1446764transections
trisections1345644trisections
unctions1039734_un__ctions
venesections1752934venesections
zonations18139314zon__ations

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.420425454.8
2DLD Change Limit1488193348.29617938.6
3Display Results3343340.1861795.7
 (SQL Overall)1786913348.90220073.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.