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

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

52 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
mesmeric144581(None) 
mesmerise1345842mesmerise
mesmerism1244802mesmerism
mesmerist1346592mesmerist
mesmerize2246032mesmerize
metameric1546192metameric
aetheric13410163aetheric
chimeric1746723chimeric
cosmetic1447773cosmetic
demerit10314993de_merit
desertic1147743des_ertic
deuteric1146333deuteric
dimeric12310013_dimeric
emetic10614453_e_metic
enteric9314213_enteric
epimeric1476763epimeric
esoteric1057593_esoteric
etheric12311783_etheric
generic101310753ge_neric
geometric14158313geometric
gesneria944053gesneria
hermetic15310243hermetic
hetaeric1346763hetaeric
homeric14312213_homeric
hysteric1647533hysteric
isomeric1247753isomeric
kismetic1644883kismetic
memetics1447803me_metics
mercuric1444393mercuric
mesenteric1453643mesenteric
mesic93617863mes___ic
mesmerised1543873mesmerised
mesmerises1445823mesmerises
mesmerisms1344143mesmerisms
mesmerists1444053mesmerists
mesmerized2444863mesmerized
mesmerizer2344093mesmerizer
mesmerizes2345993mesmerizes
mesomere1247193mesomer_e
mesomeres1347193mesomeres
mesonic11310093mes_onic
mesozoic2143613mesozoic
meteoric1247303meteoric
metric10314673me__tric
mimetic1338643m_imetic
monomeric1548213monomeric
neoteric1047853neoteric
numeric1158193_numeric
sememic1336503se_memic
steric8317063__steric
trimeric1246923trimeric
turmeric1244643turmeric

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162529.23315830.4
3Display Results52520.0163250.0
 (SQL Overall)178691529.40518999.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.