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

256 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
factions13301306(None) 
actions94218511_actions
faction122613331faction_
factious13239241factious
fictions132410741fictions
fractions1449101fractions
pactions122613501pactions
tactions102912421tactions
actinons10389452_actinons
actins86321102_acti_ns
action84719682_action_
auctions104012142auctions
bastions10411692bastions
captions123813222captions
cations94524142ca_tions
cautions103313182cautions
coactions1349742coactions
dictions111812672dictions
exactions1838922exactions
facetious1464442facetious
factional1478762factional
factoids1446242factoids
factors12912122fact_ors
falchions1743912falchions
fanions103713072fa_nions
fashions1437242fashions
fiction122010732fiction_
flections14239212flections
fraction1359482fraction_
fractious1456142fractious
frictions1448032frictions
functions1437742functions
inactions1139322inactions
kations114013662ka_tions
lections102413842lections
nations74720562na_tions
olfactions1563872olfactions
paction112713962paction_
rations74123432ra_tions
reactions11711712reactions
ructions102811682ructions
sanctions1138872sanctions
sections102714702sections
suctions103012902suctions
taction93213022taction_
tractions11511622tractions
unctions1039732unctions
vacations141910552vacations
acetins9313173_aceti_ns
actin74922553_acti_n_
acting95920983_acti_ng
actings104512463_actings
actinon9459463_actinon
actioner1048663_actioner
actioners1147723_actioners
actives12311523_actives
actors81016763_act_ors
adaptions1245223adaptions
affections1845893affections
alations82518893alations
amnions93710913_amnions
amotions1069843amotions
anions64123033_a_nions
antlions839193_antlions
auction93412933auction_
avions94114393_a_vions
axions134713483_a_xions
bacons104917583bac__ons
basions94213953ba_sions
bastion9312473bastion_
batons85519423ba_t_ons
camions113916133ca_mions
campions143511293campions
cantons95221203cant_ons
caption113513693caption_
captious122810573captious
carrions10312453carrions
cartons94122473cart_ons
cartoons104012803cartoons
cation83925503ca_tion_
caution93013523caution_
cautious103110233cautious
cions75222853__c_ions
coaction12310773coaction_
coitions10312853coitions
dacrons103211033dac_rons
daltons8310403dalt_ons
defections161510203defections
diction102313053diction_
editions9310403editions
eductions1268773eductions
ejections18249963ejections
elations83719123elations
elections112414973elections
elutions82513053elutions
emotions10610283emotions
enations83316903enations
erections112515213erections
evections142510693evections
evictions14228623evictions
exaction1738953exaction_
excitons1746043excitons
facedowns1842303facedowns
faceting1438783faceti_ng
facials123310743fac_ials
facias113415803fac_i_as
faciend1334803fac_iend
faciends1443573fac_iends
facies113921593fac_i_es
facing125321573fac_i_ng
facings134511263fac_ings
factiously1886433factiously
factitious1544083factitious
factoid1338693fact_oid
factor11911453fact_o_r
factory15108343fact_ory
facts107021893fact___s
factures13129023factures
fadeins1168503fadei_ns
fagins10513863fa_gi_ns
falchion1644343falchion_
falcons1239123fa_lcons
fanion94514323fa_nion_
fanons96115213fa__nons
fantods11177623fant_ods
fantoms12189153fant_oms
farting114120753farti_ng
fasciations1646263fasciations
fashion1337843fashion_
fashious1446123fashious
fastens105511753fast_ens
fasting114522833fasti_ng
fastings124011943fastings
fastuous1145143fastuous
fathoms1537523fa_thoms
fating105328673fa_ti_ng
fatsoes10379423fa_tsoes
fatsos9389423fa_tso_s
fattens105111713fa_ttens
fatties103018203fatti_es
fatting113818703fatti_ng
fatuous1037783fa_tuous
fenthions1544233fenthions
fermions1336203fermions
festoons1136433festoons
fetations12511383fetations
ficins113513983fic_i_ns
fictional1477793fictional
fictionist1558023fictionist
fissions1138033fissions
fixations1936353fixations
flacons1238053flac__ons
flatirons1244483flatirons
flection13239563flection_
flexions1844413flexions
fluxions1844423fluxions
fractional1547123fractional
fractioned1644613fractioned
friction1347913friction_
fruitions12106113fruitions
function1337843function_
furcations1547533furcations
fusions1039153f_usions
fustians1146403fustians
futons93911513f_ut_ons
gabions102410053ga_bions
halations12312393halations
impactions1645413impactions
inaction1039623inaction_
infarctions1645023infarctions
infections15510233infections
infractions1646963infractions
jactations1936893jactations
junctions1835943junctions
kation104315683ka_tion_
lactations1239423lactations
lacteous1046773lacteous
lactone9311393lact_one
lactones10311223lact_ones
lampions12277973lampions
latinos73613803la_tinos
lattins74115483latti_ns
lavations1238973lavations
laxations1637623laxations
lectins92515003lecti_ns
lection92614863lection_
locations112512743locations
locutions11207063locutions
lotions74614763_lotions
macons104017243mac__ons
macrons113514893mac_rons
mansions1069793mansions
martians103111613martians
martins93322063marti_ns
matins84527783ma_ti_ns
matrons93517633ma_trons
mattins93316143matti_ns
mentions10312893mentions
motions94215003_motions
nasions73112383na_sions
natations91412493natations
nation64322803na_tion_
natrons73215663na_trons
nonactions1248373nonactions
notions74014483_notions
olfaction1464233olfaction_
options93810603_options
orations81515803orations
ovations11149263ovations
partons94620513part_ons
passions10310583passions
patins87528783pa_ti_ns
patios85221783pa_tio_s
patrons93818103pa_trons
pectins112315233pecti_ns
placations1438583placations
portions10514413portions
potions93417423_potions
proactions1449343proactions
raccoons1265453raccoons
racons84319343rac__ons
racoons93912433rac_oons
rampions12248023rampions
ration64226013ra_tion_
ratios64922673ra_tio_s
ratoons73815473ra_toons
rattons73815323ra_ttons
rattoons8327513rattoons
reaction10612603reaction_
redactions1359133redactions
refections151811643refections
refractions16127723refractions
ruction93611613ruction_
ructious10277083ructious
sacatons1038973sacatons
sanction1049533sanction_
satins64930483sa_ti_ns
scions82612243_sc_ions
section92515663section_
stations82415223stations
stictions1148353stictions
suction93713043suction_
tachyons1644623tachyons
tactics1149323tacti_cs
talions7314103ta_lions
tampions12358113tampions
taxations1636863taxations
traction10412683traction_
tuitions838283tuitions
unction9310663unction_
vacation131911893vacation_
vocations141911423vocations
waitrons1136633waitrons
wanions104011373wa_nions
wantons103713013want_ons
zacatons1945703zacatons

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.1561145455.1
2DLD Change Limit1461622567.01620832.7
3Display Results2562560.0932752.7
 (SQL Overall)1786912567.26524596.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.