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

211 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
ructions10281168(None) 
auctions104012141auctions
ruction93611611ruction_
ructious10277081ructious
suctions103012901suctions
actions94218512_actions
auction93412932auction_
dictions111812672dictions
eductions1268772eductions
erections112515212erections
eruptions1146762eruptions
factions133013062factions
fictions132410742fictions
fractions1449102fractions
frictions1448032frictions
fruitions12106112fruitions
functions1437742functions
junctions1835942junctions
lections102413842lections
pactions122613502pactions
rations74123432r_ations
reactions11711712reactions
reductions1359582reductions
rutins63818392ru_ti_ns
sections102714702sections
suction93713042suction_
tactions102912422tactions
tractions11511622tractions
tuitions838282tuitions
unctions1039732unctions
abductions15125383abductions
abruptions1443843abruptions
actinons10389453_actinons
actins86321103_acti_ns
action84719683_action_
adductions14104953adductions
alations82518893alations
amotions1069843amotions
arcuations1249343arcuations
auctioned1244953auctioned
auditions1078753auditions
bastions10411693bastions
brucins1158003bruc_i_ns
bullions101710043bullions
bunions92210473bu_nions
burtons9310853burt_ons
buttons9310333bu_ttons
captions123813223captions
cations94524143_cations
cautions103313183cautions
cions75222853__c_ions
coactions1349743coactions
coitions10312853coitions
creations112614543creations
crucians1245293cruc_ians
cullions10219223cullions
cushions1335693cushions
cutins83919983cu_ti_ns
deductions1467133deductions
diction102313053diction_
directions1379643directions
ducting113713593ducti_ng
ductings12346673ductings
durations10311463durations
durions839963du_rions
editions9310403editions
educations1339233educations
eduction1169053eduction_
ejections18249963ejections
elations83719123elations
elections112414973elections
elutions82513053elutions
emotions10610283emotions
enations83316903enations
equations1839493equations
erection102115513erection_
eructations1347233eructations
eructing112110173eructi_ng
eruditions1146103eruditions
eruption1047043eruption_
evections142510693evections
evictions14228623evictions
exactions1838923exactions
excitons1746043excitons
faction122613333faction_
factious13239243factious
fiction122010733fiction_
flections14239213flections
fraction1359483fraction_
fractious1456143fractious
friction1347913friction_
fructuous1442393fructuous
fruition11106103fruition_
function1337843function_
furcations1547533furcations
fusions1039153fu_sions
fustians1146403fustians
futons93911513fu_t_ons
grunions945353gru_nions
gumptions1443773gumptions
inactions1139323inactions
inductions1348803inductions
inunctions1246753inunctions
irruptions1243893irruptions
junction1736203junction_
kations114013663_kations
lectins92515003lecti_ns
lection92614863lection_
locations112512743locations
locutions11207063locutions
lotions74614763_lotions
lunations9310723lunations
luxations1637273luxations
mentions10312893mentions
motions94215003_motions
mucins102712513muc_i_ns
mullions101910353mullions
munitions1138173munitions
munnions1035273munnions
muntins92715133munti_ns
mutations111211453mutations
mutons84314363mu_t_ons
muttons949283mu_ttons
nations74720563_nations
notions74014483_notions
nucleons1065483nucleons
nutations91411763nutations
options93810603_options
orations81515803orations
ovations11149263ovations
paction112713963paction_
pectins112315233pecti_ns
portions10514413portions
potions93417423_potions
proactions1449343proactions
productions1647533productions
puccoons1443403puccoons
pulsions1037713pulsions
punitions1137923punitions
pupations1338123pupations
putons83515153pu_t_ons
questions1845523questions
raccoons1265453raccoons
racons84319343rac__ons
racoons93912433rac_oons
rampions12248023rampions
ration64226013r_ation_
ratios64922673r_atio_s
ratoons73815473r_atoons
rattons73815323r_attons
rattoons8327513rattoons
reaction10612603reaction_
recautions1247813recautions
receptions1449743receptions
recisions1139913recisions
reckons13269653rec_kons
recoins94019243recoi_ns
recons84922993rec__ons
rectors93520523rect_ors
rectos85718783rect_o_s
redactions1359133redactions
reduction1259903reduction_
refections151811643refections
regions83613473r_egions
rejections191510103rejections
relations92418333relations
relictions12310023relictions
remotions1149703remotions
resections121513033resections
reunions837273reunions
rhytons13295883rhyt_ons
ricins83618703ric_i_ns
rockoons1445003rockoons
rogations101510823rogations
ronions73313343r_onions
rotations91613843rotations
rubious938283ru_bious
ruching133612933ruchi_ng
ruchings14287073ruchings
rucking143216673rucki_ng
ruffians1443793ruffians
ruinations1039603ruinations
ruins55822033ru__i_ns
rustics9810733rusti_cs
rusting83821263rusti_ng
rutiles74315843ru_tiles
rutin55421343ru_ti_n_
rutting82718043rutti_ng
sanctions1138873sanctions
scions82612243_sc_ions
section92515663section_
seductions1366873seductions
stations82415223stations
stictions1148353stictions
strictions1249143strictions
suasions838783suasions
suctional1147683suctional
suctioned1245283suctioned
sudations1039903sudations
sulcations1289583sulcations
taction93213023taction_
traction10412683traction_
truncations1344763truncations
trunnions943003trunnions
tuition738823tuition_
turions7311573tu_rions
unction9310663unction_
unions64216753_u_nions
urchins1238863urchi_ns
vacations141910553vacations
vocations141911423vocations

Search took 7 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.423422437.4
2DLD Change Limit1461622116.42322756.0
3Display Results2112110.0932268.8
 (SQL Overall)1786912116.93925751.7
 
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.