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

142 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
fashions143724(None) 
fashion1337841fashion_
fashious1446121fashious
basions94213952bas_ions
bastions10411692bastions
cushions1335692cushions
factions133013062factions
falchions1743912falchions
fanions103713072fa_nions
fashing144918792fashi_ng
fashioned16114462fashioned
fashioner15114322fashioner
fashioners16123962fashioners
fissions1138032fissions
fusions1039152fus_ions
lashins103915152lashi_ns
nasions73112382nas_ions
passions10310582passions
refashions1643062refashions
actions94218513_actions
amnions93710913_amnions
anions64123033_a_nions
arshins10312573arshi_ns
ashcans1235183_ashcans
ashing107824093_ashi_ng
assigns836193_assigns
avions94114393_a_vions
axions134713483_a_xions
bashing135422583bashi_ng
bashings144311243bashings
basins85722763bas_i_ns
basion84315853bas_ion_
bassoons1036553bassoons
bastion9312473bastion_
camions113916133ca_mions
campions143511293campions
captions123813223captions
carrions10312453carrions
caseins93115053casei_ns
cashiers13318883cashiers
cashing135022553cashi_ng
cashoos12310793cash_oos
casinos93512833cas_inos
cassinos10309353cassinos
cations94524143ca_tions
cautions103313183cautions
cessions1039853cessions
cushion1236403cushion_
cushiony1642583cushiony
dahoons1137753da_hoons
dasheens1244693dasheens
dashikis1643673dashikis
dashing125917893dashi_ng
dashis104414393dashi__s
dashpots1444193dashpots
erasions8310983eras_ions
ethions1038483_ethions
evasions1136543evas_ions
faction122613333faction_
factious13239243factious
fadeins1168503fadei_ns
fagins10513863fa_gi_ns
falchion1644343falchion_
falcons1239123fa_lcons
fanion94514323fa_nion_
fanons96115213fa__nons
fascias1258413fasci_as
fascine12510583fasci_ne
fascines13310143fascines
fascisms1545663fascisms
fascists1336613fascists
fascitis1346013fascitis
fashes124524023fash__es
fashioning1744393fashioning
fashionista1761933fashionista
fastens105511753fas_tens
fasting114522833fasti_ng
fastings124011943fastings
fastuous1145143fastuous
fathoms1537523fath_oms
fenthions1544233fenthions
fermions1336203fermions
festoons1136443festoons
fictions132410743fictions
fishbone1644663fishbone
fishbones1744263fishbones
fishing143913863fishi_ng
fishings15307693fishings
fishpond1773223fishpond
fishponds1852513fishponds
fission1038733fission_
flashguns1641983flashguns
flashing153711553flashi_ng
flashings16316663flashings
flexions1844413flexions
fluxions1844423fluxions
fractions1449103fractions
fusains1038363fusai_ns
fusion939773fus_ion_
fustians1146403fustians
gabions102410053ga_bions
gascons10289103gas_cons
gashing125119233gashi_ng
gaskins123510773gaski_ns
gnathions1343303gnathions
hashing145020163hashi_ng
jasmins1637083jasmi_ns
kations114013663ka_tions
lampions12277973lampions
lashing114422893lashi_ng
lashings124412253lashings
lesions73813873les_ions
mansions1069793mansions
mascons113411583mas_cons
mashies12318253mashi_es
mashing134422243mashi_ng
masons83916513mas__ons
missions10311903missions
nasion63914083nas_ion_
nations74720563na_tions
pactions122613503pactions
paphians1545593paphians
pashing135120513pashi_ng
passion9310883passion_
rampions12248023rampions
rations74123433ra_tions
refashion1543353refashion_
sashimis1343753sashimis
sashing114621473sashi_ng
sasins64923103sas_i_ns
scions82612243__scions
sessions839723sessions
shins85131043__shi_ns
suasions838783suas_ions
tachyons1644623tachyons
tactions102912423tactions
talions7314113ta_lions
tampions12358123tampions
visions10311023vis_ions
wanions104011373wa_nions
washing145119283washi_ng
washings15419273washings

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.440406115.9
2DLD Change Limit1461621427.37319824.0
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.87622688.0
 
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.