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

212 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
auction9341293(None) 
action84719681a_ction
auctions104012141auctions
ruction93611611ruction
suction93713041suction
abduction14125412abduction
actin74922552a_cti_n
actinon9459462a_ctinon
actions94218512a_ctions
adduction13225162adduction
alation72920552alation
amotion9710472amotion
auctioned1244952auctioned
audition979172audition
caution93013522cau_tion
diction102313052diction
eduction1169052eduction
faction122613332faction
fiction122010732fiction
function1337842function
junction1736202junction
lection92614862lection
paction112713962paction
ructions102811682ructions
sanction1049532sanction
section92515662section
suctions103012902suctions
taction93213022taction
tuition738822tuition
unction9310662unction
abductions15125383abductions
abjection2045323abjection
ablation10312433ablation
ablution1047223ablution
abortion1048103abortion
abruption1343973abruption
abutilon1043083abutilon
accretion1345933accretion
acetin8314693aceti_n
acting95920983a_cting
actinons10389453a_ctinons
actins86321103a_ctins
actioner1048663a_ctioner
active11313743a_ctive
actor71116073a_ct_or
actuation11310333actuation
adaption1145643adaption
addiction13146013addiction
addition1096893addition
adductions14104953adductions
adjunction2043293adjunction
adnation9310783adnation
adoption1146083adoption
adulation10311013adulation
advection1545553advection
aeration8319933aeration
affection1745893affection
agnation9311723agnation
alations82518893alations
ambition1246563ambition
amnion84812053a_mnion
amotions1069843amotions
ancon75718233anc__on
anion55028813a__nion
antlion7310293antlion
archon11311753arc_hon
arctic10313513arcti_c
arctics1138953arctics
arcuation11410583arcuation
auctioneer1262803auctioneer
auctioning1344893auctioning
audio62917103au_dio_
audios72312283au_dios
auditions1078753auditions
auditor837313auditor
auntie64317703aunti_e
aunties73920073aunties
author939763au_thor
autism83815333au_tism
autist64324943au_tist
auto47432083au_t_o_
autoing8314043au_toing
autos56523323au_t_os
autumn836013au_tumn
auxin121411913au_xi_n
aviation11312743aviation
avion84218343a__vion
avocation14168993avocation
avulsion1153863avulsion
axion1211316913a__xion
bastion9312473bastion
bullion91911033bullion
bunion83111313bu_nion
burton8311273burt_on
button8310273bu_tton
caption113513693caption
cation83925503_cation
caudation1269993caudation
causation1199523causation
cautions103313183cau_tions
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
factions133013063factions
falchion1644343falchion
fictions132410743fictions
flection13239563flection
fraction1359483fraction
friction1347913friction
fruition11106103fruition
functions1437743functions
furcation1448353furcation
fusion939773fu_sion
fustian1036903fustian
futon83113773fu_t_on
gumption1343983gumption
halation11313853halation
inaction1039623inaction
induction1248983induction
inunction1146893inunction
junctions1835943junctions
kation104315683_kation
laudation1088133laudation
lavation1139973lavation
laxation1538423laxation
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
natation81513933natation
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
ructious10277083ructious
rutin55421343ru_ti_n
sanctions1138873sanctions
scion72214993_sc_ion
sections102714703sections
seduction1266983seduction
station72717243station
stiction1038823stiction
suasion739363suasion
suctional1147683suctional
suctioned1245283suctioned
sudation9310803sudation
sulcation11710733sulcation
tactions102912423tactions
taxation1537993taxation
traction10412683traction
tuitions838283tuitions
turion6313163tu_rion
unctions1039733unctions
union54519793_u_nion
vacation131911893vacation
valuation1249973valuation
vocation132311983vocation

Search took 10 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.296603685.8
2DLD Change Limit1340272128.93614998.5
3Display Results2122120.0802650.0
 (SQL Overall)1786912129.31219189.3
 
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.