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

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

142 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
discolorations1710430(None) 
discoloration16124721discoloration_
colorations13911893___colorations
disclamations1853723disc_lamations
disconsolations1863203disconsolations
dislocations15136983dis__locations
coloration12913184___coloration_
decelerations1646424d_ecelerations
declarations1546804d_ec_larations
decollations1547364d_ecol_lations
decolorizations27136104d_ecolorizations
decorations14312884d_ec__orations
deflorations1646064d__eflorations
desolations12310594des_ol__ations
despoliations1646394despol_iations
disclamation1754244disc_lamation_
discoloring1544744discolor__i_ng
disconnections1954024disconnections
disconsolation1763414disconsolation_
discretions1447224disc___retions
disinformations2173304disinformations
dislocation14147504dis__location_
disproportions1972284dispropor_tions
disrelations1348504disrel__ations
dissociations1656014disso_ciations
dissolutions13144924dissol__utions
distillations1446944distil_lations
distortions1246614dis__tor_tions
incorporations18134854_incorporations
isolations10310694_is_ol__ations
misallocations1853094misallocations
mislocations16145654mis__locations
accelerations1754195_accelerations
auscultations1553055auscul_tations
bilocations1545295bi___locations
circulations1648485circul__ations
collations12312855___col_lations
collocations1646405___collocations
colorizations241410355___colorizations
coronations13410705___coronations
corotations1349765___corotations
corporations16129485___corporations
corroborations1882625corroborations
deceleration1547175d_eceleration_
dechlorinations2153115d_echlorinations
declamations1745305d_ec_lamations
declaration1447835d_ec_laration_
declinations15410225d_ec_linations
decollation1448195d_ecol_lation_
decolonizations27145965d_ecolonizations
decolorization26136415d_ecolorization_
decoration13314425d_ec__oration_
defloration1547265d__efloration_
defoliations1647595d_efol_iations
desalinations14410185des_alinations
desecrations1559215des__ecrations
desiderations1545675des_iderations
desolation11311405des_ol__ation_
desorptions1445995des___orptions
desperations1559525des__perations
despoliation1546715despol_iation_
deteriorations15164695deteriorations
diazotizations2353685diazotizations
dictations1389705di_c___tations
dieselizations2455915dieselizations
dilatations1246415di___latations
dilations102614455di___l__ations
disapprobations2262655disapprobations
disassociations1863165disassociations
discolors1246595discolor_____s
discolouring1652645discolo_uri_ng
discomforting2262615discomfor_ti_ng
disconnection1854205disconnection_
discouraging1753125disco_uragi_ng
discourteous1552315disco_ur_teous
discretion1347525disc___retion_
discriminations2074605discriminations
disembarkations2461505disembarkations
disinclinations1863585disinclinations
disinflations1756295dis_inflations
disinformation2063335disinformation_
disintegrations17153635disintegrations
dislocating1546735dis__locati_ng
dispensations1655485dis_pensations
displosions14203835dis_plo__sions
dispositions1546475dis__positions
disproportion1862335dispropor_tion_
disputations15106175dis__putations
disrelation1248815disrel__ation_
disseminations1755085disseminations
dissertations1465895dis_sertations
dissimilations1755865dissimilations
dissimulations1754905dissimulations
dissipations1546535dis__sipations
dissociation1556645disso_ciation_
dissolution12145025dissol__ution_
distillation1347735distil_lation_
distortion1146695dis__tor_tion_
distractions1548755dis___tractions
echolocations2052625_echolocations
escalations1347665_escal__ations
eviscerations1882705evisc__erations
explorations2185615__explorations
filtrations1445625fi___ltrations
homologations19102355_homologations
idolizations2247465_i_dolizations
immoderations1853075_immoderations
immolations1545475_immol__ations
incinerations1545685_incinerations
inclinations1448755_inc_linations
incorporation17115615_incorporation_
inculcations1666315_incul_cations
inculpations1675965_incul_pations
infiltrations1653905_infiltrations
insolations1149185_insol__ations
invigorations1753915_invigorations
isolation9311645_is_ol__ation_
misallocation1753365misallocation_
miscalculations2172835miscalculations
miscegenations1963025miscegenations
miscitations1647055misc__itations
miscoloring1644265miscolor__i_ng
miscomputations2392265miscomputations
misconceptions2263575misconceptions
misconnections2063815misconnections
miscorrelations1963005miscorrelations
miscreations1647065misc__reations
misinformations2282585misinformations
mislocation15126415mis__location_
misquotations24182725mis_quotations
obscurations1644025obsc__urations
oscillations1445115_oscil_lations
osculations1348375_oscul__ations
percolations1648055percol__ations
restorations12410955res__torations
scalations1239785__scal__ations
solations9814625__s_ol__ations
solvations1336835__s_ol_vations
spoliations1347695__spol_iations
tolerations1158135___tolerations
violations1337965vi__ol__ations
visualizations2657395visualizations

Search took 7 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.343520965.0
2DLD Change Limit950241426.31315052.1
3Display Results1421420.1101290.9
 (SQL Overall)1786911426.76626410.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.