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

127 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
factious1323924(None) 
facetious1464441facetious
factions133013061factions
fractious1456141fractious
actions94218512_actions
captious122810572captious
cautious103110232cautious
faction122613332factio_n
factiously1886432factiously
factitious1544082factitious
factoids1446242factoids
factors12912132fact_ors
fashious1446122fashious
fastuous1145142fastuous
fatuous1037782fa_tuous
fictions132410742fictions
fractions1449102fractions
lacteous1046772lacteous
pactions122613502pactions
ructious10277082ructious
tactions102912422tactions
acajous1666483_acajous
acerous9513333_acerous
acetous9410363_acetous
acinous9310933_acinous
acinus8311253_ac_inus
actings104512463_actings
actinons10389453_actinons
actins86321103_acti_ns
action84719683_actio_n
actives12311523_actives
actors81016773_act_ors
anxious1437283_anxious
auctions104012143auctions
bastions10411693bastions
cachous14312583cac_hous
cactus104912233cact__us
captions123813223captions
carious93320283ca_rious
cations94524143ca_tions
cautions103313183cautions
coactions1349743coactions
dactylus1442473dactylus
dictions111812673dictions
edacious1146023edac_ious
exactions1838923exactions
fabulous1344853fabulous
facetiously1954583facetiously
facials123310743fac_ials
facias113415803fac_i_as
facies113921593fac_i_es
facings134511263fac_ings
factful1536373fact_ful
factional1478763factional
factoid1338693fact_oid
factor11911463fact_o_r
factory15108353fact_ory
factotum1542443factotum
factotums1641923factotums
facts107021893fact___s
factures13129033factures
faitour1034883fait_our
faitours1134263fait_ours
falchions1743913falchions
famous11412393fa__mous
fanions103713073fa_nions
fantods11177623fant_ods
fantoms12189153fant_oms
fashions1437243fashions
fastidious1453473fastidious
fastings124011943fastings
fathoms1537523fa_thoms
fatigue1144393fa_tigue
fatigues1244193fa_tigues
fatsoes10379423fa_tsoes
fatsos9389423fa_tso_s
fatties103018203fatti_es
fiction122010733fictio_n
fictitious1553093fictitious
flagitious1452533flagitious
flections14239213flections
folious103710733f_olious
fraction1359483fractio_n
fractiously1985533fractiously
fractus12146593fract__us
frictions1448033frictions
fructuous1442393fructuous
fucous11399863fuc__ous
fugacious1543613fugac_ious
functions1437743functions
furious103110633f_urious
gracious1138593grac_ious
inactions1139323inactions
infectious1545603infectious
kations114013663ka_tions
lections102413843lections
manitous1039173manitous
nacreous1045763nacreous
nations74720563na_tions
nautilus844073nautilus
olfactions1563873olfactions
paction112713963pactio_n
patios85221783pa_tio_s
pectinous1345553pectinous
racemous1246953racemous
rations74123433ra_tions
ratios64922673ra_tio_s
reactions11711713reactions
ructions102811683ructions
sanctions1138873sanctions
sanious7514103sa_nious
scabious1246593scabious
scarious10610203scarious
sections102714703sections
spacious1237813spac_ious
suctions103012903suctions
tactics1149323tacti_cs
taction93213023tactio_n
tortious839023tortious
tractions11511623tractions
unctions1039733unctions
unctuous1044853unctuous
vacations141910553vacations
vacuous1237023vac_uous
various103113103va_rious
vicious1239493vic_ious
xanthous1846643xanthous

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 Limit1461621276.64022012.3
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.10925135.9
 
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.