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

208 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
reaction1061260(None) 
reactions11711711reactions
redaction1259661redaction
abreaction1444652abreaction
action84719682__action
coaction12310772coaction
creation102816512crea_tion
erection102115512erection
exaction1738952exaction
faction122613332_faction
fraction1359482fraction
inaction1039622inaction
lection92614862le_ction
paction112713962_paction
proaction13410102proaction
ration64226012r_a_tion
reacting113317892reacting
reactive13310472reactive
reactor93011662react_or
recaution1148092recaution
redactions1359132redactions
reduction1259902reduction
refection141512282refection
refraction15137902refraction
rejection181710252rejection
relation82619772relation
reliction11310692reliction
remotion10410232remotion
resection111613272resection
retraction121310532retraction
ruction93611612r_uction
section92515662se_ction
taction93213022_taction
traction10412682traction
abreactions1544193abreactions
actin74922553__acti_n
actinon9459463__actinon
actions94218513__actions
adaption1145643adaption
aeration8319933aeration
alation72920553ala_tion
auction93412933_auction
bastion9312473_bastion
beacon10511373beac__on
caption113513693_caption
cation83925503_ca_tion
caution93013523_caution
coactions1349743coactions
creatin93618133crea_ti_n
creations112614543crea_tions
cremation13511643cremation
crenation11412923crenation
deacon9510423deac__on
dealation10313003dealation
decoction1447523decoction
deduction1377083deduction
defection151610643defection
dejection19178663dejection
delation92318083delation
deletion92011973deletion
demotion1169073demotion
depiction1437273depiction
detection121310413detection
detraction13138583detraction
devotion1256763devotion
diction102313053_diction
direction1289783dire_ction
edition8310853_edition
eduction1169053eduction
ejection172510043ejection
elation73620453_elation
election102015353election
elution72913823_elution
emotion9711303_emotion
enation73419233_enation
erasion7311963era_sion
erections112515213erections
eruption1047043eruption
evection131910833evection
eviction13228683eviction
exactions1838923exactions
exciton1646083_exciton
factions133013063_factions
fetation11613143fetation
fiction122010733_fiction
flection13239563flection
fractions1449103fractions
friction1347913friction
function1337843function
gelation93014433gelation
ideation9310493idea_tion
impaction1545733impaction
inactions1139323inactions
junction1736203junction
kation104315683_ka_tion
lectin82515013le_cti_n
lections102413843le_ctions
legation92412933legation
lenition8310083lenition
location102113913location
mention9314373me_ntion
nation64322803_na_tion
negation92913023negation
nonaction1149443nonaction
olfaction1464233olfaction
oration71617713ora_tion
ovation101510023ova_tion
overaction1547993overaction
pactions122613503_pactions
pectin102615533pe_cti_n
petition10711753petition
placation1339773placation
preacting142412533preacting
precaution1447243precaution
predation12313463predation
prediction15410303prediction
prelection141511293prelection
prenotion1149173prenotion
preoption1348083preoption
proactions1449343proactions
raccoon1176163r_accoon
racon75422143r_ac__on
racoon83814473r_ac_oon
rampion11298583r_ampion
rarefaction1652653rarefaction
ratio55227583r_a_tio_
rations74123433r_a_tions
ratios64922673r_a_tios
ratoon64417373r_a_toon
ratton64116123r_a_tton
rattoon7359243r_attoon
reaching143317203reaching
react74634333react___
reactant10311433reactant
reacted103015713react_ed
reactionary1653693reactionary
reactors103212293reactors
reacts83616603react__s
reagin74915533rea_gi_n
realign838763rea_lign
realties8514853realties
realtor73611353realt_or
reason62616333rea__son
reassign955423reassign
reattain846733reattain
rebutton1043833rebutton
recautions1247813recautions
reception13410333reception
recision10310273recision
reckon123010543re_c_kon
recoin84320293re_coi_n
recon75624243re_c__on
recti73619623re_cti__
rectify1536453re_ctify
recto74520803re_ct_o_
rector84019753re_ct_or
rectos85718783re_ct_os
redacting13612303redacting
redactional1454353redactional
redactor1147033redact_or
reductions1359583reductions
reedition1047833reedition
reelection12198633reelection
refashion1543353refashion
refections151811643refections
reflation12412333reflation
reflection15168993reflection
refractions16127723refractions
region74614903re__gion
rejections191510103rejections
relations92418333relations
relaxation1746453relaxation
relictions12310023relictions
religion996743religion
relocation12312113relocation
remotions1149703remotions
rendition1058933rendition
reparation12612723reparation
repletion1147693repletion
resections121513033resections
restation9316913restation
retention91611483retention
retortion949673retortion
retractions13910353retractions
retroaction1347363retroaction
reunion737673re_union
revision1138713revision
revocation15410813revocation
rogation91612053rogation
rotation81615453rotation
ructions102811683r_uctions
sanction1049533sanction
sections102714703se_ctions
sedation9312453sedation
sedition939333sedition
seduction1266983seduction
selection11311273selection
station72717243sta_tion
stiction1038823stiction
suction93713043_suction
tactions102912423_tactions
tractions11511623tractions
unction9310663_unction
vacation131911893_vacation
venation11513503venation
vexation1838783vexation
vocation132311983vocation
zeatin15412823zea_ti_n

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 Filter1786911461620.436409841.7
2DLD Change Limit1461622087.04620744.0
3Display Results2082080.0802600.0
 (SQL Overall)1786912087.56223630.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.