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

158 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
tractions1151162(None) 
fractions1449101fractions
tactions102912421t_actions
traction10412681traction_
actions94218512__actions
attractions1376402attractions
coactions1349742coactions
detractions14118272detractions
erections112515212erections
exactions1838922exactions
extractions2077742extractions
factions133013062_factions
fraction1359482fraction_
fractious1456142fractious
frictions1448032frictions
inactions1139322inactions
orations81515802ora_tions
pactions122613502_pactions
proactions1449342proactions
rations74123432_ra_tions
reactions11711712reactions
retractions13910352retractions
ructions102811682_ructions
strictions1249142strictions
taction93213022t_action_
tractional1248052tractional
tractors10312572tract_ors
traditions1147192traditions
trajections2044512trajections
abreactions1544193abreactions
abstractions1645783abstractions
actinons10389453__actinons
actins86321103__acti_ns
action84719683__action_
adaptions1245223adaptions
aerations9317903aera_tions
alations82518893ala_tions
attraction1276953attraction_
auctions104012143_auctions
bastions10411693_bastions
captions123813223_captions
cations94524143_ca_tions
cautions103313183_cautions
coaction12310773coaction_
contractions16410403contractions
cratons94316033cra_t_ons
creations112614543creations
detraction13138583detraction_
dictions111812673_dictions
directions1379643directions
distractions1548753distractions
durations10311463dura_tions
eductions1268773eductions
ejections18249963ejections
elations83719123ela_tions
elections112414973elections
enations83316903ena_tions
erasions8310983era_sions
erection102115513erection_
eruptions1146763eruptions
evections142510693evections
evictions14228623evictions
exaction1738953exaction_
extraction1967983extraction_
faction122613333_faction_
factious13239243_factious
fictions132410743_fictions
flections14239213flections
fractional1547133fractional
fractioned1644613fractioned
friction1347913friction_
fruitions12106113fruitions
functions1437743functions
furcations1547533furcations
gracious1138593grac_ious
gradations1286863gradations
gratins84119183gra_ti_ns
gravitons1343963gravitons
gyrations1336923gyra_tions
impactions1645413impactions
inaction1039623inaction_
infractions1646963infractions
interactions14410463interactions
iterations10413823itera_tions
junctions1835943junctions
kations114013663_ka_tions
lections102413843_lections
locations112512743locations
nations74720563_na_tions
nitrations10312033nitra_tions
nonactions1248373nonactions
olfactions1563873olfactions
oration71617713ora_tion_
ovations11149263ova_tions
overactions1648213overactions
paction112713963_paction_
placations1438583placations
practices1557993practices
practises1349623practises
proaction13410103proaction_
protractions1646643protractions
raccoons1265453_raccoons
racons84319343_rac__ons
racoons93912433_rac_oons
rampions12248023_rampions
ration64226013_ra_tion_
ratios64922673_ra_tio_s
ratoons73815473_ra_toons
rattons73815323_ra_ttons
rattoons8327513_rattoons
reaction10612603reaction_
redactions1359133redactions
refractions16127723refractions
retraction121310533retraction_
retroactions1447073retroactions
ruction93611613_ruction_
ructious10277083_ructious
sanctions1138873sanctions
sections102714703_sections
stations82415223sta_tions
stictions1148353stictions
striations10312793striations
striction1148983striction_
subtractions1645373subtractions
suctions103012903_suctions
tachyons1644623t_achyons
tactics1149323t_acti_cs
talions7314113t_a_lions
tampions12358123t_ampions
tarnations1038903tarnations
taxations1636863taxations
titrations1039173titra_tions
trabeations1345373trabeations
tracing103720153trac_i_ng
tracings112910413trac_ings
tracking153715463tracki_ng
trackings16247543trackings
tractates1159763tractates
tractile10311073tracti_le
tractive13310043tracti_ve
tractor9311343tract_o_r
tracts85019073tract___s
tradition1047593tradition_
trains64725343tra__i_ns
traitors8310793trait_ors
trajection1944693trajection_
transactions1445883transactions
transections1446763transections
transitions1148923transitions
trillions947183trillions
trisections1345643trisections
tritons73814883tr_it_ons
truncations1344763truncations
trunnions943003trunnions
tuitions838283t_uitions
unctions1039733_unctions
vacations141910553_vacations
vocations141911423vocations

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.436409841.7
2DLD Change Limit1486411587.34320242.5
3Display Results1581580.0801975.0
 (SQL Overall)1786911587.85922737.1
 
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.