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

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

206 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
reactions1171171(None) 
reaction10612601reaction_
redactions1359131redactions
abreactions1544192abreactions
actions94218512__actions
coactions1349742coactions
creations112614542crea_tions
erections112515212erections
exactions1838922exactions
factions133013062_factions
fractions1449102fractions
inactions1139322inactions
lections102413842le_ctions
pactions122613502_pactions
proactions1449342proactions
rations74123432r_a_tions
reacting113317892reacti_ng
reactors103212282react_ors
recautions1247812recautions
redaction1259662redaction_
reductions1359582reductions
refections151811642refections
refractions16127722refractions
rejections191510102rejections
relations92418332relations
relictions12310022relictions
remotions1149702remotions
resections121513032resections
retractions13910352retractions
ructions102811682r_uctions
sections102714702se_ctions
tactions102912422_tactions
tractions11511622tractions
abreaction1444653abreaction_
actinons10389453__actinons
actins86321103__acti_ns
action84719683__action_
adaptions1245223adaptions
aerations9317903aerations
alations82518893ala_tions
auctions104012143_auctions
bastions10411693_bastions
beacons11410733beac__ons
captions123813223_captions
cations94524143_ca_tions
cautions103313183_cautions
coaction12310773coaction_
creatins103617513crea_ti_ns
creation102816513crea_tion_
cremations14410713cremations
crenations12511693crenations
deacons10310393deac__ons
dealations11311373dealations
decoctions1547143decoctions
deductions1467133deductions
defections161510203defections
dejections20168353dejections
delations102616593delations
deletions102610933deletions
demotions1258443demotions
depictions1546893depictions
detections131410043detections
detractions14118273detractions
devotions1356593devotions
dictions111812673_dictions
directions1379643dire_ctions
editions9310403_editions
eductions1268773eductions
ejections18249963ejections
elations83719123_elations
elections112414973elections
elutions82513053_elutions
emotions10610283_emotions
enations83316903_enations
erasions8310983era_sions
erection102115513erection_
eruptions1146763eruptions
evections142510693evections
evictions14228623evictions
exaction1738953exaction_
excitons1746043_excitons
faction122613333_faction_
factious13239243_factious
fetations12511383fetations
fictions132410743_fictions
flections14239213flections
fraction1359483fraction_
fractious1456143fractious
frictions1448033frictions
functions1437743functions
gelations102513093gelations
ideations1039903idea_tions
impactions1645413impactions
inaction1039623inaction_
junctions1835943junctions
kations114013663_ka_tions
lectins92515003le_cti_ns
lection92614863le_ction_
legations102711923legations
lenitions939473lenitions
locations112512743locations
mentions10312893me_ntions
nations74720563_na_tions
negations102811963negations
nonactions1248373nonactions
olfactions1563873olfactions
orations81515803ora_tions
ovations11149263ova_tions
overactions1648213overactions
paction112713963_paction_
pectins112315233pe_cti_ns
petitions11511083petitions
placations1438583placations
preacting142412533preacti_ng
precautions1546553precautions
predations13812153predations
predictions1649653predictions
prelections151210473prelections
prenotions1248293prenotions
preoptions1447643preoptions
proaction13410103proaction_
raccoons1265453r_accoons
racons84319343r_ac__ons
racoons93912433r_ac_oons
rampions12248023r_ampions
rarefactions1752413rarefactions
ration64226013r_a_tion_
ratios64922673r_a_tio_s
ratoons73815473r_a_toons
rattons73815323r_a_ttons
rattoons8327513r_attoons
reaching143317203reachi_ng
reactant10311433react_ant
reactants1146623reactants
reactionary1653693reactionary
reactive13310473reacti_ve
reactor93011653react_o_r
reacts83616603react___s
reagins84215643rea_gi_ns
realigns936253rea_ligns
realties8514853realti_es
realtors82811683realt_ors
reasons72514943rea__sons
reassigns1074353reassigns
reattains946443reattains
rebuttons1143503rebuttons
recaution1148093recaution_
receptions1449743receptions
recisions1139913recisions
reckons13269653re_c_kons
recoins94019243re_coi_ns
recons84922993re_c__ons
rectors93520523re_ct_ors
rectos85718783re_ct_o_s
redacting13612303redacti_ng
redactional1454353redactional
redactors1247533redact_ors
reduction1259903reduction_
reeditions1147653reeditions
reelections13167943reelections
refashions1643063refashions
refection141512283refection_
reflations13311233reflations
reflections16178553reflections
refraction15137903refraction_
regions83613473re__gions
rejection181710253rejection_
relation82619773relation_
relaxations1845643relaxations
reliction11310693reliction_
religions1086603religions
relocations13311143relocations
remotion10410233remotion_
renditions1149183renditions
reparations13611663reparations
repletions1247473repletions
resection111613273resection_
restations10315843restations
retentions101611113retentions
retortions1049143retortions
retraction121310533retraction_
retroactions1447073retroactions
reunions837273re_unions
revisions1238593revisions
revocations16410313revocations
rogations101510823rogations
rotations91613843rotations
ruction93611613r_uction_
ructious10277083r_uctious
sanctions1138873sanctions
section92515663se_ction_
sedations10311253sedations
seditions1039013seditions
seductions1366873seductions
selections12310873selections
stations82415223sta_tions
stictions1148353stictions
suctions103012903_suctions
taction93213023_taction_
traction10412683traction_
unctions1039733_unctions
vacations141910553_vacations
venations12311723venations
vexations1937753vexations
vocations141911423vocations
zeatins16311733zea_ti_ns

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 Filter1786911486410.420425454.8
2DLD Change Limit1486412067.42320024.4
3Display Results2062060.0932215.1
 (SQL Overall)1786912067.93622516.5
 
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.