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

220 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
ruction9361161(None) 
auction93412931auction
ructions102811681ructions
suction93713041suction
action84719682_action
auctions104012142auctions
diction102313052diction
eduction1169052eduction
erection102115512erection
eruption1047042eruption
faction122613332faction
fiction122010732fiction
fraction1359482fraction
friction1347912friction
fruition11106102fruition
function1337842function
junction1736202junction
lection92614862lection
paction112713962paction
ration64226012r_ation
reaction10612602reaction
reduction1259902reduction
ructious10277082ructious
rutin55421342ru_ti_n
section92515662section
suctions103012902suctions
taction93213022taction
traction10412682traction
tuition738822tuition
unction9310662unction
abduction14125413abduction
abruption1343973abruption
actin74922553_acti_n
actinon9459463_actinon
actions94218513_actions
adduction13225163adduction
alation72920553alation
amotion9710473amotion
arcuation11410583arcuation
auctioned1244953auctioned
audition979173audition
bastion9312473bastion
brucin1049133bruc_i_n
bullion91911033bullion
bunion83111313bu_nion
burton8311273burt_on
button8310273bu_tton
caption113513693caption
cation83925503_cation
caution93013523caution
cion613330923__c_ion
coaction12310773coaction
coition9314313coition
creation102816513creation
crucian1146283cruc_ian
cullion91910233cullion
cushion1236403cushion
cutin75022783cu_ti_n
deduction1377083deduction
dictions111812673dictions
direction1289783direction
ductile1048483ductile
ducting113713593ducting
duration9312693duration
durion7510963du_rion
edition8310853edition
education12310203education
eductions1268773eductions
ejection172510043ejection
elation73620453elation
election102015353election
elution72913823elution
emotion9711303emotion
enation73419233enation
equation17310483equation
erections112515213erections
eructation1248333eructation
eructing112110173eructing
erudition1046173erudition
eruptions1146763eruptions
evection131910833evection
eviction13228683eviction
exaction1738953exaction
exciton1646083exciton
factions133013063factions
fictions132410743fictions
flection13239563flection
fractions1449103fractions
frictions1448033frictions
fructify1942353fructify
fruitions12106113fruitions
functions1437743functions
furcation1448353furcation
fusion939773fu_sion
fustian1036903fustian
futon83113773fu_t_on
grunion835433gru_nion
gumption1343983gumption
inaction1039623inaction
induction1248983induction
inunction1146893inunction
irruption1143783irruption
junctions1835943junctions
kation104315683_kation
lectin82515013lecti_n
lections102413843lections
location102113913location
locution10227663locution
lotion65716523_lotion
lunation8311923lunation
luxation1538233luxation
mention9314373mention
motion85217553_motion
mucin93116823muc_i_n
mullion91911173mullion
multiton1087343multiton
munition1038763munition
munnion935863munnion
muntin82915183munti_n
mutation101412883mutation
muton73817003mu_t_on
mutton8510453mu_tton
nation64322803_nation
notion64516583_notion
nucleon945553nucleon
nutation81513103nutation
option83612713_option
oration71617713oration
ovation101510023ovation
pactions122613503pactions
pectin102615533pecti_n
portion9615493portion
potion84519573_potion
proaction13410103proaction
production1547893production
puccoon1343503puccoon
pulsion938393pulsion
punition1038373punition
pupation1269503pupation
puton73617913pu_t_on
question1745823question
raccoon1176163raccoon
racon75422143rac__on
racoon83814473rac_oon
rampion11298583rampion
ratio55227583r_atio_
rations74123433r_ations
ratios64922673r_atios
ratoon64417373r_atoon
ratton64116123r_atton
rattoon7359243rattoon
reactions11711713reactions
recaution1148093recaution
reception13410333reception
recision10310273recision
reckon123010543rec_kon
recoin84320293recoi_n
recon75624243rec__on
recti73619623recti__
rectify1536453rectify
recto74520803rect_o_
rector84019753rect_or
rectos85718783rect_os
redaction1259663redaction
reductions1359583reductions
refection141512283refection
region74614903r_egion
rejection181710253rejection
relation82619773relation
reliction11310693reliction
remotion10410233remotion
resection111613273resection
reunion737673reunion
rhyton12356113rhyt_on
ricin74620213ric_i_n
rockoon1345653rockoon
rogation91612053rogation
ronion63315643r_onion
rotation81615453rotation
ruching133612933ruching
rucking143216673rucking
ruffian1344133ruffian
ruin47430513ru__i_n
ruination9311273ruination
runtier73512853runtier
runtish1048693runtish
rustic8712673rusti_c
rustics9810733rustics
rustier74416363rustier
rustily103112993rustily
rusting83821263rusting
rutile65217683ru_tile
rutins63818393ru_tins
ruttier73412283ruttier
ruttily10338613ruttily
rutting82718043rutting
ruttish1048303ruttish
sanction1049533sanction
scion72214993_sc_ion
sections102714703sections
seduction1266983seduction
station72717243station
stiction1038823stiction
striction1148983striction
suasion739363suasion
suctional1147683suctional
suctioned1245283suctioned
sudation9310803sudation
sulcation11710733sulcation
tactions102912423tactions
tractions11511623tractions
truncation1245453truncation
trunnion843273trunnion
tuitions838283tuitions
turion6313163tu_rion
unctions1039733unctions
union54519793_u_nion
urchin1138743urchi_n
vacation131911893vacation
vocation132311983vocation

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272207.25018486.5
3Display Results2202200.1731271.7
 (SQL Overall)1786912207.84322783.5
 
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.