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 “erraticisms” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
erraticisms155483(None) 
erraticism1455271erraticism_
eroticisms1457992e_roticisms
criticisms1656183_criticisms
eroticism13219183e_roticism_
eroticists1278193e_roticists
erratics1046983erratic___s
exoticisms2155713e_xoticisms
fanaticisms1854063fanaticisms
hermeticisms2153973hermeticisms
neuroticisms1653813neuroticisms
organicisms1653013organicisms
relativisms1653913relativisms
vorticisms1745783vor_ticisms
asceticisms1753764asceticisms
atticisms1367414__atticisms
ceramicists1753874ceramicists
chromaticisms2463444chromaticisms
creationisms1685524creationisms
cretinisms1446714_cretinisms
criticises1446444_criticises
criticism1556844_criticism_
dermatitises1553264dermatitises
didacticisms2061824didacticisms
eclecticisms1753114eclecticisms
empiricisms1952484empiricisms
eremitisms1445034e_remitisms
erethisms1445384e_ret_hisms
ergotisms1245304ergot__isms
eroticist11712074e_roticis_t
eroticizes2146944e_roticizes
erotisms10310164e_rot__isms
errancies1147964erra_nci_es
erratic9311124erratic____
erratical1146904erratic__al
erratically16410124erratically
erythrisms1854044e_rythrisms
estheticisms1953204estheticisms
etatisms1038294e_tat__isms
exoticism2046494e_xoticism_
exoticists1945824e_xoticists
fanaticism1754634fanaticism_
freneticisms1972554freneticisms
gnosticisms1673624gnosticisms
hermeticism2054744hermeticism_
keratitises15145154keratitises
laicisms1247124__la_icisms
lyricisms161979014lyr__icisms
mercantilisms1962534mercantilisms
metricisms1646524metr__icisms
monasticisms1853334monasticisms
mosaicisms1644184mosa_icisms
mysticisms1944604_mysticisms
nativisms14105994__nativisms
negativisms1753254negativisms
neuroticism1554474neuroticism_
organicism1553554organicism_
organicists1453174organicists
parasitisms1575504parasitisms
poeticisms1647344_poeticisms
pragmaticisms2292384pragmaticisms
racisms112310814__ra__cisms
raticides1248694__raticides
relativism1554414relativism_
relativists1464554relativists
rhotacisms1743014_rhotacisms
romanticisms18184364romanticisms
routinisms1245784_routinisms
scepticisms1963534scepticisms
skepticisms2172774skepticisms
teratisms11410074terat__isms
vorticism1646394vor_ticism_
vorticists1546084vor_ticists
witticisms1793474_witticisms

Search took 10 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 Filter1786911488190.440406115.9
2DLD Change Limit148819749.14016282.2
3Display Results74740.0461608.7
 (SQL Overall)178691749.62618563.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.