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

203 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
suction9371304(None) 
auction93412931auction
ruction93611611ruction
section92515661section
suctions103012901suctions
action84719682_action
auctions104012142auctions
diction102313052diction
eduction1169052eduction
faction122613332faction
fiction122010732fiction
function1337842function
junction1736202junction
lection92614862lection
paction112713962paction
ructions102811682ructions
sanction1049532sanction
scion72214992s_c_ion
sections102714702sections
seduction1266982seduction
station72717242station
stiction1038822stiction
suasion739362suasion
suctional1147682suctional
suctioned1245282suctioned
sudation9310802sudation
sulcation11710732sulcation
taction93213022taction
tuition738822tuition
unction9310662unction
abduction14125413abduction
actin74922553_acti_n
actinon9459463_actinon
actions94218513_actions
adduction13225163adduction
alation72920553alation
amotion9710473amotion
auctioned1244953auctioned
audition979173audition
bastion9312473bastion
bisection13136983bisection
bullion91911033bullion
bunion83111313bu_nion
burton8311273burt_on
button8310273bu_tton
caption113513693caption
cation83925503_cation
caution93013523caution
cion613330913__c_ion
coaction12310773coaction
coition9314313coition
cullion91910233cullion
cushion1236403cushion
cutin75022783cu_ti_n
deduction1377083deduction
dictions111812673dictions
ductile1048483ductile
ducting113713593ducting
duration9312693duration
durion7510963du_rion
edition8310853edition
education12310203education
eductions1268773eductions
ejection172510043ejection
elation73620453elation
election102015353election
elution72913823elution
emotion9711303emotion
enation73419233enation
equation17310483equation
erection102115513erection
eruption1047043eruption
evection131910833evection
eviction13228683eviction
exaction1738953exaction
exciton1646083exciton
exsection1847493exsection
factions133013063factions
fictions132410743fictions
flection13239563flection
fraction1359483fraction
friction1347913friction
fruition11106103fruition
functions1437743functions
furcation1448353furcation
fusion939773fu_sion
fustian1036903fustian
futon83113773fu_t_on
gumption1343983gumption
inaction1039623inaction
induction1248983induction
inunction1146893inunction
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
puccoon1343503puccoon
pulsion938393pulsion
punition1038373punition
pupation1269503pupation
puton73617913pu_t_on
question1745823question
ration64226013_ration
reaction10612603reaction
reduction1259903reduction
resection111613273resection
ructious10277083ructious
rutin55421343ru_ti_n
sacaton938993sacaton
sanctions1138873sanctions
satin55935223s_ati_n
scions82612243s_c_ions
scullion1065633scullion
secretion11118303secretion
sectile9311973sectile
sectional1149423sectional
sectioned1246523sectioned
sector83415933sect_or
sedation9312453sedation
sedition939333sedition
seductions1366873seductions
selection11311273selection
session739763session
seton55223543s_et_on
sexton133610793sext_on
sinuation9310413sinuation
situation949423situation
solation8916153solation
solion6616383s_olion
soliton7410233soliton
solution889593solution
sorption1037513sorption
statin63921473stati_n
stations82415223stations
stetson745783stetson
stictions1148353stictions
stotin63215063stoti_n
striction1148983striction
suasions838783suasions
subduction1544683subduction
subito8410453subito_
subjection2165973subjection
subjoin1645443subjoin
sublation11311013sublation
subsection1496783subsection
subtaxon1742743subtaxon
subteen938523subteen
subtile91912623subtile
subtilin1047123subtilin
subtone9310343subt_one
succor1036623suc_cor
suckier133613973suckier
sucking143217413sucking
suctioning1345343suctioning
suctorian11106503suctorian
sudations1039903sudations
suiting83419003suiting
suitor63311053suit_or
sulcations1289583sulcations
sulfation1288783sulfation
sultan63012593sult_an
summation1347803summation
summon1037623su_mmon
suntan62613003sunt_an
surgeon837003surgeon
surjection1974903surjection
sustain738773sustain
symbion1464043symbion
tactions102912423tactions
traction10412683traction
tuitions838283tuitions
turion6313163tu_rion
unctions1039733unctions
union54519793_u_nion
vacation131911893vacation
vocation132311983vocation

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272035.86022871.5
3Display Results2032030.0802537.5
 (SQL Overall)1786912036.34628158.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.