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

348 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
refractions1612772(None) 
refraction15137901refraction_
retractions13910351retractions
detractions14118272detractions
fractions1449102__fractions
infractions1646962infractions
reactions11711712re__actions
redactions1359132re_dactions
refections151811642ref_ections
reflations13311232refla_tions
reflections16178552reflections
refracting1638732refracti_ng
refractors15156272refract_ors
retraction121310532retraction_
retroactions1447072retroactions
aerations9317903ae_ra_tions
attractions1376403attractions
defecations1779003defecations
defections161510203def_ections
deflations1439713defla_tions
deflections17187323deflections
detraction13138583detraction_
diffractions2153273diffractions
erections112515213_e_rections
exactions1838923_e_xactions
extractions2077743extractions
factions133013063__f_actions
fraction1359483__fraction_
fractious1456143__fractious
frictions1448033__frictions
infarctions1645023infarctions
infraction1557453infraction_
olfactions1563873olf_actions
overactions1648213overactions
perfections1848143perfections
protractions1646643protractions
rarefactions1752413raref_actions
reaction10612603re__action_
recautions1247813re_cautions
recreations13412253recreations
redaction1259663re_daction_
redirections1546163redirections
reductions1359583re_ductions
reelections13167943reelections
refashions1643063ref_ashions
refection141512283ref_ection_
reflation12412333refla_tion_
reflection15168993reflection_
reformations1747603reformations
refractile1544143refracti_le
refractive1846693refracti_ve
refractor14156323refract_o_r
refractory18134773refract_ory
refracts13137383refract___s
refrains1139593refra__i_ns
refutations1448673refutations
reifications17411823reifications
rejections191510103re_jections
relations92418333re_la_tions
relictions12310023re_lictions
relocations13311143relocations
reparations13611663reparations
resections121513033re_sections
restations10315843resta_tions
restrictions1449283restrictions
retracting13311933retracti_ng
retractors12158583retract_ors
retroaction1347363retroaction_
revocations16410313revocations
serrations10313093serra_tions
tractions11511623__tractions
aberrations1346694aberra_tions
abreactions1544194abreactions
abstractions1645784abstractions
actions94218514____actions
adorations11310234adora_tions
aeration8319934ae_ra_tion_
affections1845894_affections
afflictions1943404afflictions
anfractuous1651364anfractuous
attraction1276954attraction_
benefactions1952694benefactions
bifurcations1982934bifurcations
ceratins102818734ce_ra_ti_ns
cerebrations1646964cerebra_tions
cessations1256474cessa_tions
coactions1349744__coactions
cofunctions1845014cofunctions
compactions1946534compactions
contractions16410404contractions
corrections1548864corrections
creations112614544cre__a_tions
cremations14410714cre_ma_tions
crenations12511694cre_na_tions
deaerations12311674deaera_tions
dealations11311374deala_tions
decoctions1547144de_coctions
decorations14312884decora_tions
decryptions1943614decryptions
dedications15310874dedications
deductions1467134de_ductions
defalcations1845194defalcations
defamations1745894defamations
defecation1679804defecation_
defection151610644def_ection_
definitions1545604definitions
deflation13310654defla_tion_
deflection16147734deflection_
deflorations1646064deflora_tions
deformations1846844deformations
degradations1544554degradations
deifications18410654deifications
dejections20168354de_jections
delations102616594de_la_tions
demarcations1746124demarcations
dentations11413634denta_tions
depictions1546894de_pictions
depravations1885374depravations
deprecations1748564deprecations
destructions1547254destructions
detections131410044de_tections
detracting1438714detracti_ng
detractors13147294detract_ors
detritions1148954detr_itions
deviations14311164devia_tions
diffraction2053494diffraction_
directions1379634_directions
distractions1548754distractions
durations10311464_dura_tions
educations1339234_educations
eductions1268774_e_ductions
ejections18249964_e_jections
elations83719124_e_la_tions
elections112414974_e_lections
enations83316904_e_na_tions
equations1839494_equa_tions
erasions8310984_e_ra_sions
erection102115514_e_rection_
eruptions1146764_e_ruptions
evections142510694_e_vections
evictions14228624_e_victions
evocations15259874_evocations
exaction1738954_e_xaction_
execrations2048924execra_tions
exsections1947634_exsections
extraction1967984extraction_
faction122613334__f_action_
factious13239244__f_actious
federations1548884federa_tions
fellations1338064fella_tions
fetations12511384fe_ta_tions
fictions132410744__f_ictions
flections14239214__flections
fractional1547124__fractional
fractioned1644614__fractioned
friction1347914__friction_
fruitions12106114__fruitions
functions1437744__functions
furcations1547534_furcations
gelations102513094ge_la_tions
gemmations1545004gemma_tions
generations12311424genera_tions
gestations1139774gesta_tions
gyrations1336924_gyra_tions
hydrations1745274hydra_tions
impactions1645414_impactions
inactions1139324__inactions
infarction1545794infarction_
infections15510234inf_ections
inflations13310324infla_tions
inflections1646984inflections
inflictions1645444inflictions
infracting1647354infracti_ng
infractors1566004infract_ors
interactions14410464interactions
iterations10413824itera_tions
keratins122313484ke_ra_ti_ns
lections102413844le___ctions
legations102711924le_ga_tions
librations12149064libra_tions
malefactions1953144malef_actions
mediations13310984media_tions
medications1649934medications
mentations12312584menta_tions
metrications1649834metrications
migrations13168684migra_tions
narrations1038944narra_tions
negations102811964ne_ga_tions
nervations1359484ne_rvations
nitrations10312034nitra_tions
nonactions1248374_nonactions
olfaction1464234olf_action_
operations12312954opera_tions
orations81515804__ora_tions
overaction1547994overaction_
overreactions1854724overreactions
pactions122613504___pactions
peltations12311554pelta_tions
perditions1348874pe_rditions
perfection1748364perfection_
perforations1747874perfora_tions
perorations13314064perora_tions
petrifactions2083564petrifactions
precautions1546554pre_cautions
predations13812154pre_da_tions
predications17411184predications
predictions1649654pre_dictions
preformations2045714preformations
prelections151210464pre_lections
preparations1648314preparations
proactions1449344_proactions
prorations12314464prora_tions
protraction1547214protraction_
putrefactions2052274putref_actions
radiations11311924radia_tions
rarefaction1652654raref_action_
rations74123434___ra_tions
reacting113317894re__acti_ng
reactors103212284re__act_ors
recaution1148094re_caution_
receptions1449744re_ceptions
recitations13314204recitations
reclamations1645714reclamations
recordations1548644recordations
recrating121318794recra_ti_ng
recreation12413614recreation_
redacting13612304re_dacti_ng
redactional1454344re_dactional
redactors1247534re_dact_ors
redemptions1643734redemptions
redirection1446044redirection_
redrafting1545964redrafti_ng
reduction1259904re_duction_
reeditions1147654re_editions
reeducations1545474reeducations
reelection12198634reelection_
reenacting1357354reenacti_ng
reenactors1294384reenact_ors
reerecting1339974reerecti_ng
refacing142512814ref_ac_i_ng
refashion1543354ref_ashion_
refastens1244754ref_ast_ens
refecting152413354ref_ecti_ng
reflating132514714refla_ti_ng
reflecting1638824reflecti_ng
reflectional1753984reflectional
reflectors1545504reflect_ors
reflexions2043304ref_lexions
reformation1648414reformation_
refract121311604refract____
refracted1557394refract__ed
refractively2354774refractively
refractiveness2254854refractiveness
refractivity2353504refractivity
refractories1754494refractories
refrain10310044refra__i_n_
refraining1437264refraini_ng
reframing1538624refra_mi_ng
refronting1437274refronti_ng
refutation1349914refutation_
regrafting1545994regrafti_ng
regranting1238324regranti_ng
regrating111316214regra_ti_ng
regressions1247104regressions
regulations12310714regulations
rehydrations1943984rehydra_tions
reification16412904reification_
reignitions1244554reignitions
reinfections1745324reinfections
reinflations1546644reinfla_tions
reinjections2144404reinjections
reiterations12410874reitera_tions
rejection181710254re_jection_
relation82619774re_la_tion_
relaxations1845644relaxations
relegations1248974relegations
reliction11310694re_liction_
relocation12312114relocation_
remigrations15227794remigra_tions
remotions1149704re__motions
renditions1149184re_nditions
renovations1448424renovations
reoperations14410064reopera_tions
reparation12612724reparation_
repartitions1444964repartitions
repetitions1378024repetitions
repletions1247474re_pletions
replications16811054replications
repositions131110164repositions
repressions1348964repressions
reprobations1647774reprobations
reproductions1865274reproductions
reputations13410734reputations
reracking1639314re_racki_ng
reradiations1349494re_radiations
resection111613274re_section_
reservations1588584reservations
resolutions11117794resolutions
resorptions1347234resorptions
respirations14410304respira_tions
restation9316914resta_tion_
restorations12410954restora_tions
restriction1349364restriction_
resumptions15154594resumptions
resurrections1553464resurrections
retardations1396514retardations
retentions101611114re_tentions
retortions1049144re_tortions
retracing12313294retrac_i_ng
retracking1738164retracki_ng
retractile1246254retracti_le
retractor11218514retract_o_r
retracts101111314retract___s
retrains8314534retra__i_ns
retributions14134944retributions
retroacting1447284retroacti_ng
retrodictions1655534retrodictions
revelations14410304revelations
revocation15410814revocation_
revolutions1497634revolutions
rogations101510824r_oga_tions
rotations91613844r_ota_tions
rubrications1646264rubrications
ructions102811684___ructions
ruinations1039604ruina_tions
secretions12117844secr_etions
sections102714704se___ctions
sedations10311254se_da_tions
seductions1366874se_ductions
selections12310874se_lections
sensations1059854sensa_tions
separations1369274separations
seriations10316684se_riations
serration9414064serra_tion_
strictions1249144_strictions
subtractions1645374subtractions
tactions102912424___tactions
titrations1039174titra_tions
traction10412684__traction_
transactions1445884transactions
trifurcations1852864trifurcations
tumefactions1951624tumef_actions
venations12311724ve_na_tions
venerations14411314venera_tions
veracious1447124ve_rac_ious
vernations13310334ve_rnations
vexations1937754ve_xa_tions
vibrations15157374vibra_tions

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 Filter1786911488190.1561145455.1
2DLD Change Limit1488193489.03016480.5
3Display Results3483480.2031714.3
 (SQL Overall)1786913489.38919032.0
 
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.