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

143 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
fermions133620(None) 
fermion1236761fermion_
fermionic1643512fermionic
fermis114313502fermi__s
fermiums1544352fermiums
pereions10310852pereions
sermons9311782serm_ons
ternions838812ternions
thermions1445332thermions
versions11310352versions
aerations9317903aerations
aversions1247053aversions
berlins93216013berli_ns
berming123614833bermi_ng
camions113916133_camions
carrions10312453carrions
cessions1039853cessions
coercions1346203coercions
demons94917723de_m_ons
deraigns1034883deraigns
derisions1038843derisions
dermis94717163dermi__s
dermises112512023dermises
dermoids1246163dermoids
dormins10311273dormi_ns
durions839963dur_ions
emersions1147283emersions
erasions8310983_erasions
ermine8416923_ermi_ne
ermines9416673_ermines
erosions8310343_erosions
ethions1038483_ethions
eversions1238363eversions
exertions1639763exertions
factions133013063factions
fanions103713073f_anions
farming133515083farmi_ng
farmings14298223farmings
fashions1437243fashions
feigns10407753fe__igns
felons93615763fe__lons
fenthions1544233fenthions
fenurons1174963fenurons
ferias95020393fer_i_as
ferine96422583fer_i_ne
ferlies103216693ferli_es
fermatas13246223fermatas
ferment12315573ferm_ent
ferments13311473ferments
fermi103914163fermi___
fermium1446353fermi_um
ferninst11238323ferni_nst
ferns85220083fer___ns
ferocious1445193ferocious
ferreous1146033ferreous
ferries103521083ferri_es
ferrites112312833ferrites
ferritins1247273ferritins
ferrous1049793fer_rous
fervors1336233fer_vors
festoons1136443festoons
fetations12511383fetations
fictions132410743fictions
firkins1437663firki_ns
firmans12238523firm_ans
firming132811223firmi_ng
fissions1138033fissions
flections14239213flections
flexions1844413flexions
fluxions1844423fluxions
formations1538203formations
formicas1546003formicas
forming133615733formi_ng
formols12299413form_ols
fremitus1344023fremitus
frons86124043f_r__ons
furious103110633fur_ious
fusions1039153f_usions
germans1079473germ_ans
germens1078633germ_ens
germina1038503germi_na
harmins123716723harmi_ns
hellions11310023hellions
hemins113417573he_mi_ns
heriots10312063her_iots
hermits12312143hermi_ts
heroins103518013heroi_ns
herons94820543her__ons
jerkins18358253jerki_ns
kermis124012393kermi__s
kermises14248313kermises
lections102413843lections
legions84611783le_gions
lemons84415053le_m_ons
lesions73813873le_sions
mentions10312893mentions
merinos9311983mer_inos
merlins93015813merli_ns
merlons93311273mer_lons
morions94014643mor_ions
morrions1077673morrions
myrmidons1741643myrmidons
pensions10311693pensions
pereion9312053pereion_
pereons92815003per_eons
perigons11310083perigons
periods10312243per_iods
permian112612283permian_
perming123416093permi_ng
permits11314003permi_ts
perniones1148593perniones
perrons93115483per_rons
persons93717013per_sons
pervious1337543pervious
portions10514413portions
prions84317783_pr_ions
regions83613473re_gions
reunions837273reunions
sections102714703sections
sereins73716123serei_ns
serins64029673ser_i_ns
serious73616283ser_ious
sermon8413553serm_on_
sessions839723sessions
tensions8310223tensions
terming104016003termi_ng
termini93410813termi_ni
terminus1037393terminus
termites10313693termites
termors94712773term_ors
ternion739493ternion_
tertians839103tertians
thermion1345933thermion_
torsions839183torsions
turions7311573tur_ions
verdins112812333verdi_ns
vermian12329713vermian_
vermilions1543873vermilions
vermin113414523vermi_n_
verminous1445573verminous
vermis114214963vermi__s
version10310923version_
virions1039873vir_ions

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 Limit1461621437.23320207.7
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.71923149.5
 
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.