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

69 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
meropias124996(None) 
meropia1149611meropia_
ametropias1454782ametropias
cecropias1545112cecropias
melodias1148702melodias
meropic13310262meropi_c
myopias14308152m_yopias
senopias1048822senopias
abrosias1049033abrosias
aerobia939463aerobia_
aerobics1246833aerobics
ambrosias1345333ambrosias
ametropia1345103ametropia_
anopias92412483_anopias
atrophias1447933atrophias
atropins10410493atropins
begonias1146263begonias
cecropia1455153cecropia_
celosias1048903celosias
cerias83321983cer__ias
ectopias1248273ectopias
emeroids11147723emero_ids
erotics91914153_erotics
ferias95020393fer__ias
hernias10310773her_nias
heroics122912003hero_ics
heroins103518013hero_ins
hyperopias2047373hyperopias
kerrias11289513ker_rias
mahonias1348063mahonias
medias93620783me__dias
meiosis939023meiosi_s
melodia1038883melodia_
melodicas1444853melodicas
melodies11310123melodies
meloids10911453melo_ids
memoirs1136803memo_irs
memorial1249523memorial
memorials1346553memorials
memories121214353memories
mercies113817563mer_cies
meridian1147683meridian
meridians1245543meridians
merisis93213173merisi_s
merits8320873mer__its
merlins93015813mer_lins
mermaids1355753mermaids
metepas1136303metep_as
metopae1147743metop_ae
metopes11311363metop_es
metopic1339763metopi_c
metopons12107023metopons
morphias1546843morphias
myopia13318443m_yopia_
myopies14309723m_yopies
nerolis71012773neroli_s
pelorias10410593pelorias
peroxids1837453peroxids
recopies12313733recopies
senopia949233senopia_
sepias83616103se__pias
serosas7312663sero_sas
sinopias1047873sinopias
terbias9310743ter_bias
tropics113610653_tropics
tropins93116313_tropins
utopias9117723_utopias
veronicas1446393veronicas
xerosis14249663xerosi_s

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 Limit146162697.29620033.2
3Display Results69690.0302300.0
 (SQL Overall)178691697.76623009.4
 
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.