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

202 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
suctions10301290(None) 
auctions104012141auctions
ructions102811681ructions
sections102714701sections
suction93713041suction_
actions94218512_actions
auction93412932auction_
dictions111812672dictions
eductions1268772eductions
factions133013062factions
fictions132410742fictions
functions1437742functions
junctions1835942junctions
lections102413842lections
pactions122613502pactions
ruction93611612ruction_
ructious10277082ructious
sanctions1138872sanctions
scions82612242s_c_ions
section92515662section_
seductions1366872seductions
stations82415222stations
stictions1148352stictions
suasions838782suasions
suctional1147682suctional
suctioned1245282suctioned
sudations1039902sudations
sulcations1289582sulcations
tactions102912422tactions
tuitions838282tuitions
unctions1039732unctions
abductions15125383abductions
actinons10389453_actinons
actins86321103_acti_ns
action84719683_action_
adductions14104953adductions
alations82518893alations
amotions1069843amotions
auctioned1244953auctioned
auditions1078753auditions
bastions10411693bastions
bisections14136733bisections
bullions101710043bullions
bunions92210473bu_nions
burtons9310853burt_ons
buttons9310333bu_ttons
captions123813223captions
cations94524143_cations
cautions103313183cautions
cions75222853__c_ions
coactions1349743coactions
coitions10312853coitions
cullions10219223cullions
cushions1335693cushions
cutins83919983cu_ti_ns
deductions1467133deductions
diction102313053diction_
ducting113713593ducti_ng
ductings12346673ductings
durations10311463durations
durions839963du_rions
editions9310403editions
educations1339233educations
eduction1169053eduction_
ejections18249963ejections
elations83719123elations
elections112414973elections
elutions82513053elutions
emotions10610283emotions
enations83316903enations
equations1839493equations
erections112515213erections
eruptions1146763eruptions
evections142510693evections
evictions14228623evictions
exactions1838923exactions
excitons1746043excitons
exsections1947633exsections
faction122613333faction_
factious13239243factious
fiction122010733fiction_
flections14239213flections
fractions1449103fractions
frictions1448033frictions
fruitions12106113fruitions
function1337843function_
furcations1547533furcations
fusions1039153fu_sions
fustians1146403fustians
futons93911513fu_t_ons
gumptions1443773gumptions
inactions1139323inactions
inductions1348803inductions
inunctions1246753inunctions
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
puccoons1443403puccoons
pulsions1037713pulsions
punitions1137923punitions
pupations1338123pupations
putons83515153pu_t_ons
questions1845523questions
rations74123433_rations
reactions11711713reactions
reductions1359583reductions
resections121513033resections
rutins63818393ru_ti_ns
sacatons1038973sacatons
sanction1049533sanction_
satins64930483s_ati_ns
scion72214993s_c_ion_
scullions1154683scullions
secretions12117853secretions
sectional1149423sectional
sectionals1247273sectionals
sectioned1246523sectioned
sectors93116453sect_ors
sedations10311253sedations
seditions1039013seditions
seduction1266983seduction_
selections12310873selections
sessions839723sessions
setons64620173s_et_ons
sextons143710413sext_ons
sinuations1039413sinuations
situations1038433situations
solations9814623solations
solions7513753s_olions
solitons849593solitons
solutions988883solutions
sorptions1137123sorptions
statins73719773stati_ns
station72717243station_
stetsons845623stetsons
stiction1038823stiction_
stotins73213873stoti_ns
strictions1249143strictions
suasion739363suasion_
subductions1644503subductions
subjections2296353subjections
subjoins1745453subjoins
sublations12410113sublations
subsections1597103subsections
subtaxons1842683subtaxons
subteens1037423subteens
subtilins1147173subtilins
subtone9310343subt_one
subtones10311383subt_ones
succors1137413suc_cors
sucking143217413sucki_ng
suctioning1345343suctioning
suctorians12114723suctorians
sudation9310803sudation_
suiting83419003suiti_ng
suitings9288953suitings
suitors73012493suit_ors
sulcation11710733sulcation_
sulfations13107813sulfations
sultans72411833sult_ans
summations1456783summations
summons1158003su_mmons
suntans72111733sunt_ans
surgeons947033surgeons
surjections2075283surjections
sustains838553sustains
symbions1563933symbions
taction93213023taction_
tractions11511623tractions
tuition738823tuition_
turions7311573tu_rions
unction9310663unction_
unions64216753_u_nions
vacations141910553vacations
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 Filter1786911461620.406440125.6
2DLD Change Limit1461622027.42319690.4
3Display Results2022020.0762657.9
 (SQL Overall)1786912027.90522604.8
 
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.