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

148 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
combustion164456(None) 
combustions1744531combustions
combusting1745452combusting
combustive1953752combustive
combustor1543702combust_or
collusion1146413collus_ion
combination17108803combination
combust1338363combust___
combusted1644643combust_ed
combustible1952863combustible
combustibly2252373combustibly
combustors1643753combustors
combusts1445503combust__s
commission1645623commission
commotion1576983com_motion
communion1546363commu_nion
commutation1748003commutation
compaction1846753compaction
compassion1645983compassion
completion1647303completion
composition1746793composition
compulsion1644673compulsion
compunction19115903compunction
computation1748713computation
concussion14155573concussion
conduction1549963conduction
confusion1446473confus_ion
congestion1349043congestion
contusion1147063contus_ion
corruption1455373corruption
precombustion2162243precombustion
ambition1246564_amb_ition
ambulation1447874_ambulation
bastion9312474___bastion
bombastic1743764bombasti_c
bombesin1444234bombes_i_n
bombination1765014bombination
carburetion1562544carburetion
causation1199524c__ausation
caution93013524c__au_tion
coaction12310774co__action
coagulation1447274coagulation
coalition1148704co_alition
coaptation1448344coaptation
coeducation1646234coeducation
cofunction1745254cofunction
cogitation13410084cogitation
cognation12310754co_gnation
cognition1247014co_gnition
cohesion1347284co_hes_ion
coition9314314co___ition
colistin10410554co_listi_n
collation11313994co_llation
collection1448204collection
collision1146944collis_ion
collusions1245974collus_ions
coloration12913184coloration
combating16310164comb_ating
combative1847214comb_ative
combatting1755144combatting
combinations1897924combinations
combustibles2061754combustibles
commination171111644commination
comminution17105014comminution
commissions1745264commissions
commotions1686844com_motions
communions1656184commu_nions
commutations1847264commutations
commuting16288444commu_ting
compactions1946544compactions
companion1577684com_panion
compassions1745774compassions
compensation18126504compensation
competition1755774competition
compilation1749314compilation
completions1746914completions
complexion2343754complexion
compositions1846254compositions
compositor1644634compositor
composting17178054composting
compression1756564compression
compulsions1744594compulsions
compunctions20145694compunctions
compurgation19134184compurgation
computations1848124computations
computing16309854compu_ting
computist1547324compu_tist
conation101420884co__nation
conception16410454conception
concession14148134concession
concision1348494concis_ion
conclusion1445224conclus_ion
concoction1348234concoction
concretion1449294concretion
concussions15125324concussions
condition12411164co_ndition
conductions1649664conductions
confection17411184confection
confession15126504confession
conflation15412084conflation
confusions1546304confus_ions
confutation1668724confutation
congestions1449314congestions
conjugation2146624conjugation
conjunction2245624conjunction
conjuration2049514conjuration
connation11314264co_nnation
connection14410534connection
conniption1446274conniption
consumption1745424consumption
contention12412224contention
contortion1248664contortion
contrition12411414contrition
contusions1246994contus_ions
convection17411124convection
convention15410564convention
conviction1748184conviction
convulsion1544434convulsion
cooption1288344co__option
copulation141111954copulation
coronation12412074coronation
corotation12410974corotation
corrasion1146484corras_ion
correction1448814correction
corrosion1146054corros_ion
corrugation1445994corrugation
corruptions1555174corruptions
coruscation1545694co_ruscation
countian1048124co__untian
cousin8517164co__us_i_n
cumulation1448174cumulation
cushion1236404c___ushion
domination13712374domination
exhaustion2052884exhaustion
lobation102110554lo_b_ation
lobulation1247234lo_bulation
locution10227664lo_cu_tion
nomination12712104nomination
oblation1039864_o_blation
occlusion1343974occlus_ion
omission1046534_om_ission
pollution1146004pollu_tion
precombustions2262054precombustions
robustious1252474ro_bustious
rumbustious1551444rumbustious
solution889594so_lu_tion
tombstone1343814tomb_st_one
volution1198604vo_lu_tion

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 Filter1786911614500.453394461.4
2DLD Change Limit1614501489.39017193.8
3Display Results1481480.0801850.0
 (SQL Overall)1786911489.92318007.8
 
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.