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

237 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
dictions11181267(None) 
diction102313051diction_
fictions132410741fictions
actions94218512_actions
addictions14125362addictions
auctions104012142auctions
depictions1546892depictions
diatrons939622diatrons
dictations1389702dictations
dictional1268612dictional
dilations102614452dilations
dilutions10248582dilutions
directions1379642directions
editions9310402edi_tions
eductions1268772eductions
evictions14228622evictions
factions133013062factions
fiction122010732fiction_
frictions1448032frictions
indictions1339312indictions
lections102413842lections
pactions122613502pactions
ructions102811682ructions
sections102714702sections
stictions1148352stictions
suctions103012902suctions
tactions102912422tactions
unctions1039732unctions
abdications1657653abdications
abductions15125383abductions
actinons10389453_actinons
actins86321103_acti_ns
action84719683_action_
adaptions1245223adaptions
addiction13146013addiction_
additions1186333additions
adductions14104953adductions
adnations1039753adnations
adoptions1245793adoptions
advections1645553advections
alations82518893alations
amotions1069843amotions
auction93412933auction_
auditions1078753audi_tions
aviations12311553aviations
bastions10411693bastions
bicrons113410473bic_rons
bijections21134933bijections
bilections14136503bilections
billions102211793billions
biotins93114453bioti_ns
biotrons1037243biotrons
bisections14136733bisections
captions123813223captions
cations94524143_cations
cautions103313183cautions
cions75222853__c_ions
cistrons102710643cistrons
citations11312503citations
citrons92913223ci_trons
coactions1349743coactions
coitions10312853coitions
dacrons103211033dac_rons
daltons8310403dalt_ons
decagons1235893decagons
deceptions1547863deceptions
decisions1248383decisions
decoctions1547143decoctions
decurions1246023decurions
dedications15310873dedications
deductions1467133deductions
defections161510203defections
deictics1345563deicti_cs
dejections20168353dejections
delations102616593delations
deletions102610933deletions
demotions1258443demotions
dentins83419223denti_ns
depiction1437273depiction_
detections131410043detections
deviations14311163deviations
devotions1356593devotions
diamins10312213diami_ns
diatoms1039073diat_oms
diatron839283diatron_
diazinons1941993diazinons
diazins1739183diazi_ns
dicing105718763dic_i_ng
dickens144410133dic_kens
dickies143416343dicki_es
dicking153617613dicki_ng
diclinous1244103diclinous
dicliny1337673dicli_ny
dicots94915793dic__ots
dictates11311383dictates
dictation12810563dictation_
dictators1247363dictators
dictier103411863dicti_er
dictiest113212783dictiest
dictionary1654593dictionary
dictums1235553dict_ums
diecious1146873diecious
dieting93616833dieti_ng
digestions1246403digestions
dilation92215463dilation_
dilution9239143dilution_
diluvions13224443diluvions
dinting93520553dinti_ng
dioxins1568003dioxi_ns
direction1289783direction_
dirties83119383dirti_es
discretions1447233discretions
disjoins1647623disjoins
dislimns1144813dislimns
dissections14198263dissections
distains9413603distains
distichs1447633distichs
distills9319043distills
distils83015803disti_ls
disunions1055973disunions
ditties83116983ditti_es
dittoing1036263dittoing
dittos74111973di_tto_s
diurons838823di_urons
divisions1396283divisions
doctors1039993doct_ors
donations101112353donations
dotations101411633dotations
ducting113713593ducti_ng
ductings12346673ductings
durations10311463durations
durions839963d_urions
edition8310853edi_tion_
educations1339233educations
eduction1169053eduction_
ejections18249963ejections
elations83719123elations
elections112414973elections
elutions82513053elutions
emotions10610283emotions
enations83316903enations
erections112515213erections
evections142510693evections
eviction13228683eviction_
exactions1838923exactions
excitons1746043excitons
faction122613333faction_
factious13239243factious
ficins113513983fic_i_ns
fictional1477803fictional
fictionist1558023fictionist
fissions1138033fissions
fixations1936353fixations
flections14239213flections
fractions1449103fractions
friction1347913friction_
functions1437743functions
himations1438803himations
icons76516493_ic__ons
ideations1039903ideations
inactions1139323inactions
indications14310973indications
indiction1239813indiction_
inductions1348803inductions
inions64417003_i_nions
introns73515023_introns
jillions15178283jillions
junctions1835943junctions
kations114013663_kations
lectins92515003lecti_ns
lection92614863lection_
libations112510443libations
lictors93212603lict_ors
ligations102111993ligations
locations112512743locations
locutions11207063locutions
lotions74614763_lotions
mediations13310983mediations
medications1649933medications
mentions10312893mentions
microns113814783mic_rons
millions101712433millions
minions93314623mi_nions
missions10311903missions
motions94215003_motions
nations74720563_nations
nicotins1058173nicoti_ns
nictations1278313nictations
nidations1039213nidations
nitons64614903ni_t_ons
notions74014483_notions
options93810603_options
orations81515803orations
ovations11149263ovations
paction112713963paction_
pectins112315233pecti_ns
pillions101610923pillions
pinions93413603pi_nions
pistons93016373pist_ons
pitons85319043pi_t_ons
plications14310493plications
portions10514413portions
potions93417423_potions
predictions1649653predictions
radiations11311933radiations
rations74123433_rations
reactions11711713reactions
redactions1359133redactions
reductions1359583reductions
relictions12310023relictions
ricins83618703ric_i_ns
ruction93611613ruction_
ructious10277083ructious
sanctions1138873sanctions
scions82612243_sc_ions
section92515663section_
seditions1039013sedi_tions
seductions1366873seductions
stations82415223stations
stiction1038823stiction_
strictions1249143strictions
suction93713043suction_
taction93213023taction_
tictocs1145903tict_ocs
titians72710453ti_tians
tractions11511623tractions
tuitions838283tuitions
unction9310663unction_
vacations141910553vacations
vibrions1345093vibrions
vicious1239493vic_ious
victims1436003victi_ms
victors123311183vict_ors
virions1039873vi_rions
visions10311023vi_sions
vocations141911423vocations
zillions17168073zillions

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.423422437.4
2DLD Change Limit1461622376.51622431.2
3Display Results2372370.0932548.4
 (SQL Overall)1786912377.03225411.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.