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

80 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
meropia114961(None) 
meropias1249961meropias
meropic13310261meropic
aerobia939462aerobia
ametropia1345102ametropia
cecropia1455152cecropia
melodia1038882melodia
metopic1339762metopic
myopia13318442m_yopia
senopia949222senopia
abrosia939273abrosia
acromia1139963acromia
aerobic11310213aerobic
ambrosia1245543ambrosia
ametropias1454783ametropias
ametropic1545653ametropic
anopia83412393_anopia
atrophia1348103atrophia
atropin9311583atropin
begonia1047213begonia
cecropias1545113cecropias
celosia939463celosia
ceria75125353cer__ia
cerotic11415053cerotic
ectopia1147693ectopia
emeroid101511183emero_id
emporia1148753emporia
erotic82620263_erotic
erotica92811513_erotica
feria85922713fer__ia
hernia9312293her_nia
heroic113516923hero_ic
heroin94420593hero_in
hyperopia1947143hyperopia
kerria10339913ker_ria
mahonia1238443mahonia
maria75032883mar__ia
marsupia1242473marsupia
media84721713me__dia
meiosis939023meiosis
meiotic11410923meiotic
melodias1148703melodias
melodic1238543melodic
melodica1344983melodica
meloid9616003melo_id
memoir1037213memo_ir
memorial1249523memorial
meridian1147683meridian
merisis93213173merisis
merit7339183mer__it
merlin83916683mer_lin
mermaid1297853mermaid
mesonic11310093mesonic
metepa1066013metep_a
metopae1147743metopae
metope10611123metop_e
metopes11311363metopes
metopon11137073metopon
moronic11311863moronic
morphia1447483morphia
myopias14308153m_yopias
myopic15308463m_yopic
neroli61111153neroli_
nerolis71012773nerolis
peloria9310953peloria
pereia85217983per_eia
peridia10312363peridia
peroxid17310263peroxid
propria1149933_propria
senopias1048823senopias
sepia75318673se__pia
serosa6313023sero_sa
sinopia947733sinopia
terbia8311153ter_bia
tropic103014193_tropic
tropin83316753_tropin
utopia8107883_utopia
veronica1346733veronica
xerosis14249663xerosis
xerotic16410853xerotic

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027807.04619021.7
3Display Results80800.0302666.7
 (SQL Overall)178691807.23224708.4
 
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.