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 “auctions” 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
auctions10401214(None) 
actions94218511a_ctions
auction93412931auction_
ructions102811671ructions
suctions103012901suctions
abductions15125382abductions
actinons10389452a_ctinons
actins86321102a_cti_ns
action84719682a_ction_
adductions14104952adductions
alations82518892alations
amotions1069842amotions
auctioned1244952auctioned
auditions1078752auditions
cautions103313162cau_tions
dictions111812672dictions
eductions1268772eductions
factions133013062factions
fictions132410742fictions
functions1437742functions
junctions1835942junctions
lections102413842lections
pactions122613502pactions
ruction93611612ruction_
ructious10277072ructious
sanctions1138872sanctions
sections102714702sections
suction93713042suction_
tactions102912422tactions
tuitions838282tuitions
unctions1039732unctions
abduction14125413abduction_
abjections2145663abjections
ablations11311503ablations
ablutions1146593ablutions
abortions1147783abortions
abruptions1443833abruptions
abutilons1142963abutilons
accretions1444923accretions
acetins9313173aceti_ns
actin74922553a_cti_n_
acting95920983a_cti_ng
actings104512463a_ctings
actinon9459463a_ctinon
actioner1048663a_ctioner
actioners1147713a_ctioners
actives12311523a_ctives
actors81016753a_ct_ors
actuations1239293actuations
adaptions1245223adaptions
addictions14125363addictions
additions1186333additions
adduction13225163adduction_
adjunctions2143143adjunctions
adnations1039753adnations
adoptions1245783adoptions
adulations11310123adulations
advections1645553advections
aerations9317903aerations
affections1845893affections
agnations10310033agnations
alation72920553alation_
ambitions1346343ambitions
amnions93710913a_mnions
amotion9710473amotion_
anions64123033a__nions
antlions839193antlions
archons12311583arc_hons
arctics1138953arcti_cs
arcuations1249333arcuations
auctioneer1262803auctioneer
auctioneers1362273auctioneers
auctioning1344893auctioning
audios72312283au_dio_s
audition979173audition_
auditors947613auditors
aunties73920073aunti_es
authors10311833au_thors
autisms94311553au_tisms
autists73814853au_tists
autoing8314043au_toing
autos56523323au_t_o_s
autumns943763au_tumns
auxins13129813au_xi_ns
aviations12311553aviations
avions94114393a__vions
avocations15168683avocations
avulsions1243263avulsions
axions134713483a__xions
bastions10411693bastions
bullions101710033bullions
bunions92210473bu_nions
burtons9310853burt_ons
buttons9310333bu_ttons
captions123813213captions
cations94524143_cations
caudations13108223caudations
causations1268143causations
caution93013513cau_tion_
cautious103110223cau_tious
cions75222853__c_ions
coactions1349733coactions
coitions10312843coitions
cullions10219213cullions
cushions1335693cushions
cutins83919983cu_ti_ns
deductions1467123deductions
diction102313053diction_
ducting113713593ducti_ng
ductings12346673ductings
durations10311463durations
durions839963du_rions
editions9310403editions
educations1339223educations
eduction1169053eduction_
ejections18249963ejections
elations83719123elations
elections112414963elections
elutions82513053elutions
emotions10610283emotions
enations83316903enations
equations1839493equations
erections112515193erections
eruptions1146753eruptions
evections142510693evections
evictions14228623evictions
exactions1838923exactions
excitons1746043excitons
faction122613333faction_
factious13239243factious
falchions1743913falchions
fiction122010733fiction_
flections14239213flections
fractions1449103fractions
frictions1448033frictions
fruitions12106103fruitions
function1337843function_
furcations1547533furcations
fusions1039153fu_sions
fustians1146403fustians
futons93911513fu_t_ons
gumptions1443773gumptions
halations12312393halations
inactions1139323inactions
inductions1348803inductions
inunctions1246753inunctions
junction1736203junction_
kations114013663_kations
laudations1146843laudations
lavations1238973lavations
laxations1637623laxations
lectins92515003lecti_ns
lection92614863lection_
locations112512743locations
locutions11207053locutions
lotions74614763_lotions
lunations9310723lunations
luxations1637273luxations
mentions10312893mentions
motions94215003_motions
mucins102712513muc_i_ns
mullions101910343mullions
munitions1138173munitions
munnions1035273munnions
muntins92715133munti_ns
mutations111211453mutations
mutons84314363mu_t_ons
muttons949283mu_ttons
natations91412493natations
nations74720563_nations
notions74014483_notions
nucleons1065483nucleons
nutations91411763nutations
options93810593_options
orations81515793orations
ovations11149263ovations
paction112713963paction_
pectins112315233pecti_ns
portions10514393portions
potions93417423_potions
puccoons1443403puccoons
pulsions1037713pulsions
punitions1137923punitions
pupations1338123pupations
putons83515153pu_t_ons
questions1845523questions
rations74123433_rations
reactions11711713reactions
reductions1359583reductions
rutins63818393ru_ti_ns
sanction1049533sanction_
scions82612233_sc_ions
section92515663section_
seductions1366873seductions
stations82415213stations
stictions1148343stictions
suasions838783suasions
suctional1147683suctional
suctioned1245273suctioned
sudations1039903sudations
sulcations1289583sulcations
taction93213023taction_
taxations1636863taxations
tractions11511613tractions
tuition738823tuition_
turions7311573tu_rions
unction9310663unction_
unions64216753_u_nions
vacations141910553vacations
valuations1348783valuations
vocations141911423vocations

Search took 9 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.186960704.3
2DLD Change Limit1461622118.12617987.0
3Display Results2112110.0762776.3
 (SQL Overall)1786912118.38821303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.