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

321 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
deflections1718732(None) 
defections161510201def_ections
deflection16147731deflection_
reflections16178551reflections
defecations1779002def_ecations
defection151610642def_ection_
deflations1439712defl_ations
deflecting1736502deflecti_ng
deflectors1654772deflect_ors
deflexions2142562defle_xions
dejections20168352de_jections
deletions102610932de_le_tions
depletions1355742deple_tions
detections131410042de_tections
elections112414972_e_lections
flections14239212__flections
inflections1646992inflections
reelections13167942reelections
refections151811642ref_ections
reflection15168992reflection_
selections12310872se_lections
affections1845893_affections
afflictions1943403afflictions
bilections14136503_bilections
bolections14137293_bolections
collections1547933collections
dealations11311373deal_ations
deceptions1547863de_ceptions
declensions1443333declensions
decoctions1547143de_coctions
deductions1467133de_ductions
defalcations1845193defalcations
defamations1745893defamations
defecation1679803def_ecation_
defecting162510223def_ecti_ng
defectives1945683def_ectives
defectors15237883def_ect_ors
definitions1545603definitions
deflation13310653defl_ation_
deflective1956093deflecti_ve
deflector1555063deflect_o_r
deflects14336733deflect___s
deflexion2042823defle_xion_
deflorations1646063deflorations
defoliations1647593defoliations
dejection19178663de_jection_
delations102616593de_l_ations
delectations1547453de_lectations
delegations1348033de_legations
deletion92011973de_le_tion_
depictions1546893de_pictions
depletion1256663deple_tion_
deprecations1748563deprecations
derelictions1544333derelictions
desertions1139883de_sertions
detection121310413de_tection_
detentions11148803de_tentions
detractions14118273detractions
directions1379643d_irections
dissections14198263dissections
ejections18249963_e_jections
election102015353_e_lection_
electrons112411753_e_lectrons
erections112515213_e_rections
evections142510693_e_vections
exsections1947633_exsections
flection13239563__flection_
genuflections1951513genuflections
infections15510233inf_ections
inflection1547633inflection_
inflictions1645443inflictions
lections102413843___lections
perfections1848143perfections
prelections151210473prelections
reelection12198633reelection_
refection141512283ref_ection_
reflations13311233refl_ations
reflecting1638823reflecti_ng
reflectional1753993reflectional
reflectors1545503reflect_ors
reflexions2043303refle_xions
refractions16127723refractions
rejections191510103re_jections
relictions12310023re_lictions
repletions1247473reple_tions
resections121513033re_sections
selection11311273se_lection_
abjections2145674_abjections
advections1645554_advections
affection1745894_affection_
affliction1843544affliction_
beflecking2243034beflecki_ng
bijections21134934_bijections
bilection13156804_bilection_
bisections14136734_bisections
bolection13117674_bolection_
cofunctions1845014cofunctions
collection1448204collection_
confections18411394confections
conflictions1945224conflictions
connections15410704connections
convections18411494convections
corrections1548864corrections
deaerations12311674deaerations
dealation10313004deal_ation_
decelerations1646424decelerations
deception1448324de_ception_
decimations16410164decimations
declamations1745304declamations
declarations1546804declarations
declension1343514declension_
declinations15410224declinations
decoction1447524de_coction_
decollations1547364decollations
decorations14312884decorations
decryptions1943614decryptions
dedications15310874dedications
deduction1377084de_duction_
defalcation1746224defalcation_
defamation1646844defamation_
defeating142311974def_eati_ng
defeatisms1643174def_eatisms
defeatists1443424def_eatists
defecating17237784def_ecati_ng
defecators1656254def_ecators
defective1848004def_ecti_ve
defector14277954def_ect_o_r
defects134511524def_ect___s
definition1445964definition_
deflagrations1883024deflagrations
deflating142610714defl_ati_ng
deflators13348154defl_at_ors
defleaing1444744defle_ai_ng
deflect13399974deflect____
deflectable1943804deflectable
deflected1635984deflect__ed
defloration1547264defloration_
defoliation1548314defoliation_
deformations1846844deformations
deglaciations1753914deglaciations
deglutitions1452154deglutitions
deifications18410654deifications
dejecting20217794de_jecti_ng
delation92318084de_l_ation_
delectates1348194de_lectates
delectation1448554de_lectation_
delegation1238884de_legation_
deleting103314424de_le_ti_ng
delicious1246714de_lic_ious
delineations1346764delineations
delusions1037054de_l_usions
demarcations1746124demarcations
demetons1137624de_me_t_ons
demolitions1446524demolitions
demotions1258444de__motions
denegations1348544denegations
denotations1239854denotations
dentations11413634de_ntations
dentitions1148854de_ntitions
denudations1346344denudations
depiction1437274de_piction_
depilations14310904depilations
depleting1378194deple_ti_ng
depositions14117684depositions
deprecation1648964deprecation_
depreciations1846574depreciations
depredations1646734depredations
depressions1447314depressions
deputations1448344deputations
dereliction1444574dereliction_
derivations15611494derivations
derogations1349394derogations
descensions1444374descensions
desecrations1559214de_secrations
deselecting1544474deselecti_ng
desertion10410204de_sertion_
desiccations1755654desiccations
desolations12310594desolations
desorptions1445994desorptions
desperations1559524desperations
destructions1547254destructions
detecting13259984de_tecti_ng
detectives1645784de_tectives
detectors12278304de_tect_ors
detention10169544de_tention_
detonations1239374detonations
detraction13138584detraction_
detritions1148954de_tritions
deuterations1348084deuterations
devaluations1646354devaluations
deviations14311164de_viations
devolutions15106264devolutions
devotions1356594de__votions
dialectics1544214dialecti_cs
dictions111812674d___ictions
diffractions2153274diffractions
digestions1246404d_igestions
dilations102614454d_il_ations
dilutions10248584d_il_utions
direction1289784d_irection_
disaffections2253044disaffections
disfunctions1854524disfunctions
dislocations15136984dislocations
dissection13158614dissection_
dissentions12168044dissentions
distentions12178844distentions
duplications1746284duplications
dysfunctions2152134dysfunctions
dyslectics18102794dyslecti_cs
eclectics1254814_eclecti_cs
eductions1268774_e_ductions
effecting1845584_effecti_ng
effectives21134564_effectives
effectors1755034_effect_ors
egestions1046704_e_gestions
ejection172510044_e_jection_
elations83719124_e_l_ations
electing112113784_e_lecti_ng
electives1448934_e_lectives
electors103013844_e_lect_ors
electron102611414_e_lectron_
electros102811744_e_lectro_s
elevations1338634_e_levations
elocutions1245964_e_locutions
elutions82513054_e_l_utions
erection102115514_e_rection_
evection131910834_e_vection_
evictions14228624_e_victions
exactions1838924_e_xactions
exceptions2146864_exceptions
executions1946394_e_xecutions
exertions1639764_e_xertions
exsection1847494_exsection_
exsertions1746744_exsertions
factions133013064__f_actions
fellations1338064fe_llations
fictions132410744__f_ictions
flexions1844414__fle_xions
fractions1449104__fractions
frictions1448034__frictions
functions1437744__functions
gelations102513094ge_l_ations
genuflection1851614genuflection_
impletions1445004imple_tions
infarctions1645024infarctions
infection14410474inf_ection_
infectious1545604inf_ectious
inflations13310324infl_ations
inflecting1646314inflecti_ng
inflectional1754384inflectional
inflectors1545224inflect_ors
inflexions2042894infle_xions
infliction1545944infliction_
infractions1646964infractions
injections1948664_injections
inspections1546424inspections
intellections1565394intellections
lectins92515004___lecti_ns
lection92614864___lection_
midsections1644404midsections
neglecting1444544neglecti_ng
neglectors1363544neglect_ors
nonelections1456394nonelections
nucleations1345314nucleations
objections2145634_objections
olfactions1563874olf_actions
peltations12311554pe_ltations
perceptions1798194perceptions
perfection1748364perfection_
permeations1549884permeations
persecutions1654794persecutions
plectrons13258074__plectrons
predilections1853564predilections
preelection15136484preelection_
prelection141511294prelection_
preselections17144444preselections
projections2258474projections
protections15510704protections
reactions11711714re__actions
receptions1449744re_ceptions
recollections1754724recollections
recreations13412254recreations
redactions1359134re_dactions
redirections1546174redirections
reductions1359584re_ductions
reelecting1338784reelecti_ng
refecting152413354ref_ecti_ng
reflation12412334refl_ation_
reflective1857124reflecti_ve
reflector1445734reflect_o_r
reflects13288874reflect___s
reflexion1943614refle_xion_
refraction15137904refraction_
refutations1448674refutations
reinfections1745324reinfections
reinjections2144404reinjections
rejection181710254re_jection_
relations92418334re_l_ations
relegations1248974re_legations
reliction11310694re_liction_
relocations13311144re_locations
repletion1147694reple_tion_
replications16811054replications
resection111613274re_section_
retentions101611114re_tentions
retractions13910354retractions
retroflections1953874retroflections
revelations14410304revelations
secretions12117854secre_tions
sections102714704___sections
seductions1366874se_ductions
selecting12310534se_lecti_ng
selectionist1458084se_lectionist
selectors1148964se_lect_ors
subjections2296354subjections
subsections1597104subsections
surjections2075284surjections
telethons1246024te_le_thons
trajections2044514trajections
trisections1345644trisections
venesections1752934venesections

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.403443402.0
2DLD Change Limit1488193217.90618823.6
3Display Results3213210.1901689.5
 (SQL Overall)1786913218.49921024.9
 
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.