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

196 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
fictions13241074(None) 
dictions111812671dictions
factions133013061factions
fiction122010731fiction_
frictions1448031frictions
actions94218512_actions
auctions104012142auctions
diction102313052diction_
evictions14228622evictions
faction122613332faction_
factious13239242factious
ficins113513982fic_i_ns
fictional1477802fictional
fictionist1558022fictionist
fissions1138032fissions
fixations1936352fixations
flections14239212flections
fractions1449102fractions
friction1347912friction_
functions1437742functions
lections102413842lections
pactions122613502pactions
ructions102811682ructions
sections102714702sections
stictions1148352stictions
suctions103012902suctions
tactions102912422tactions
unctions1039732unctions
actinons10389453_actinons
actins86321103_acti_ns
action84719683_action_
addictions14125363addictions
affections1845893affections
afflictions1943403afflictions
alations82518893alations
amotions1069843amotions
auction93412933auction_
aviations12311553aviations
bastions10411693bastions
bicrons113410473bic_rons
bijections21134933bijections
bilections14136503bilections
billions102211793billions
biotins93114453bioti_ns
biotrons1037233biotrons
bisections14136733bisections
captions123813223captions
cations94524143_cations
cautions103313183cautions
cions75222853__c_ions
cistrons102710623cistrons
citations11312503citations
citrons92913223ci_trons
coactions1349743coactions
coitions10312853coitions
defections161510203defections
depictions1546893depictions
diatrons939613diatrons
dictations1389703dictations
dictional1268613dictional
dilations102614453dilations
dilutions10248583dilutions
directions1379643directions
editions9310403editions
eductions1268773eductions
ejections18249963ejections
elations83719123elations
elections112414973elections
elutions82513053elutions
emotions10610283emotions
enations83316903enations
erections112515213erections
evections142510693evections
eviction13228683eviction_
exactions1838923exactions
excitons1746043excitons
facetious1464443facetious
factional1478763factional
factoids1446243factoids
factors12912123fact_ors
falchions1743913falchions
fanions103713073f_anions
fashions1437243fashions
fenthions1544233fenthions
fermions1336203fermions
festoons1136443festoons
fetations12511383fetations
fibrins1238633fibri_ns
fibroins1346213fibroins
ficin103516723fic_i_n_
ficoes114613463fic__oes
fictile1238023ficti_le
fictioneer1553123fictioneer
fictioneers1652683fictioneers
fictionists1655993fictionists
fictionize2454203fictionize
fictionizes2554103fictionizes
fictitious1553093fictitious
fictive1537023ficti_ve
fifteens1442753fifteens
fifties132111083fifti_es
filiations13119093filiations
firkins1437663firki_ns
fission1038733fission_
fisting113818123fisti_ng
fitting113516563fitti_ng
fittings12318203fittings
fixation1837073fixation_
flatirons1244483flatirons
flection13239563flection_
flexions1844413flexions
fluxions1844423fluxions
foliations1399943foliations
fraction1359483fraction_
fractious1456143fractious
frictional1546253frictional
fruitions12106113fruitions
function1337843function_
furcations1547533furcations
fusions1039153f_usions
fustians1146403fustians
futons93911513f_ut_ons
himations1438803himations
icons76516493_ic__ons
inactions1139323inactions
indictions1339313indictions
infections15510233infections
inflictions1645443inflictions
inions64417003_i_nions
introns73515023_introns
jillions15178283jillions
junctions1835943junctions
kations114013663_kations
lectins92515003lecti_ns
lection92614863lection_
libations112510443libations
lictors93212593lict_ors
ligations102111993ligations
locations112512743locations
locutions11207063locutions
lotions74614763_lotions
mentions10312893mentions
microns113814783mic_rons
millions101712433millions
minions93314623mi_nions
missions10311903missions
motions94215003_motions
nations74720563_nations
nicotins1058173nicoti_ns
nictations1278313nictations
nidations1039213nidations
nitons64614903ni_t_ons
nonfictions1645933nonfictions
notions74014483_notions
olfactions1563873olfactions
options93810603_options
orations81515803orations
ovations11149263ovations
paction112713963paction_
pectins112315233pecti_ns
pillions101610923pillions
pinions93413603pi_nions
pistons93016373pist_ons
pitons85319043pi_t_ons
plications14310493plications
portions10514413portions
potions93417423_potions
rations74123433_rations
reactions11711713reactions
refections151811643refections
relictions12310023relictions
ricins83618703ric_i_ns
ruction93611613ruction_
ructious10277083ructious
sanctions1138873sanctions
scions82612243_sc_ions
section92515663section_
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.406440125.6
2DLD Change Limit1461621967.29620033.2
3Display Results1961960.0802450.0
 (SQL Overall)1786911967.78222962.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.