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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

94 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
diffractions215327(None) 
diffraction2053491diffraction_
diffracting2143342diffracti_ng
distractions1548752distractions
infractions1646962_infractions
bifurcations1982933bifurcations
detractions14118273d_etractions
diffracts1843223diffract___s
directions1379633di__rections
disfunctions1854523disfunctions
distraction1449113distraction_
fractions1449103___fractions
infarctions1645023_infarctions
infraction1557453_infraction_
refractions16127723_refractions
abstractions1645784abstractions
affections1845894_aff_ections
afflictions1943404_afflictions
attractions1376404_attractions
bifurcation1863374bifurcation_
contractions16410404contractions
deaerations12311674deaera_tions
decorations14312884decora_tions
defalcations1845194defalcations
defamations1745894defama_tions
defecations1779004defeca_tions
defections161510204d_ef_ections
deflations1439714d_efla_tions
deflections17187324d_eflections
deflorations1646064deflora_tions
deformations1846844deformations
deifications18410654deifica_tions
demarcations1746124demarcations
destructions1547254destructions
detraction13138584d_etraction_
dictations1389704di_cta_tions
dictions111812674di____ctions
diffract1744724diffract____
diffracted2042974diffract__ed
diffusions1743734diff__usions
dilatations1246414dilata_tions
dilations102614454di__la_tions
direction1289774di__rection_
disaffections2253044disaffections
discretions1447224discr_etions
disfunction1754714disfunction_
disjunctions2254074disjunctions
dislocations15136984dislocations
disruptions14125684di_sruptions
dissections14198264di_ssections
distinctions1557324distinctions
distracting1569254distracti_ng
divagations16103834divaga_tions
divarications1955504divarications
divinations15128414divina_tions
durations10311464d__ura_tions
dysfunctions2152134dysfunctions
edifications1848694edifica_tions
extractions2077744_extractions
factions133013064___f_actions
figurations1545084figura_tions
filtrations1445624filtra_tions
fraction1359484___fraction_
fractious1456144___fractious
frictions1448034___frictions
furcations1547534__furcations
impactions1645414_i_mpactions
inactions1139324_i__nactions
infarction1545794_infarction_
infections15510234_inf_ections
inflations13310324_infla_tions
inflections1646984_inflections
inflictions1645444_inflictions
infracting1647354_infracti_ng
infractors1566004_infract_ors
interactions14410464interactions
iterations10413824_itera_tions
liberations1358944libera_tions
librations12149064li_bra_tions
literations11610584litera_tions
migrations13168684mi_gra_tions
misfunctions1953714misfunctions
nitrations10312034ni_tra_tions
olfactions1563874_olf_actions
overactions1648214_overactions
protractions1646644protractions
refraction15137904_refraction_
retractions13910354_retractions
subtractions1645374subtractions
suffocations2053094suffocations
titrations1039174ti_tra_tions
tractions11511624___tractions
trifurcations1852864trifurcations
vibrations15157374vi_bra_tions

Search took 8 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 Filter1786911247900.1601116818.8
2DLD Change Limit124790947.39016886.3
3Display Results94940.0462043.5
 (SQL Overall)178691947.59623524.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.