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

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

67 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
mealies9282193(None) 
mealie82519811mealie_
mealier93015901mealier
mealiest102215971mealiest
meanies93620741meanies
beanies93821092beanies
belies84631052be_lies
bellies94023722bellies
bialies93618412bialies
dearies83526272dearies
dellies83622212dellies
easies64126632_easies
fealties1139992fealties
fellies104119742fellies
ferlies103216692ferlies
goalies8316022goalies
heavies132713872heavies
jellies143816532jellies
kellies113516852kellies
lealties8310792lealties
mailes84329112m_ailes
males75049792m_al_es
malices114316622m_alices
malines93625602m_alines
mamies104626242m_amies
mavies114923192m_avies
mealiness11310062mealiness
mealless10288362mealless
meals75933372meal__s
mealtimes1345242mealtimes
meanie83718392meanie_
measles92412752measles
measlier1036012measlier
measliest1147172measliest
meatier93214612meatier
meatiest102816792meatiest
medflies1435552medflies
meinies92516072meinies
melees83618082me_lees
mercies113817562mercies
merles85322762merl_es
merlins93015812merlins
metalise10416052metalise
metalises11315072metalises
metalizes20414242metalizes
mislies92922282mislies
molies84429512m_olies
mollies93420232mollies
muhlies1238932muhlies
nellies73418722nellies
peavies122213402peavies
readies83324712readies
reales64934122real_es
realise73021812realise
realises82420182realises
realizes173116842realizes
realties8514852realties
reflies104418532reflies
relies65036422re_lies
replies94521042replies
tellies73820502tellies
vealier102712172vealier
vealiest112513202vealiest
walies95324522_walies
wearies103020222wearies
wellies103719072wellies
yearlies1137602yearlies

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 Filter1786911076710.373479064.3
2DLD Change Limit107671676.72016022.5
3Display Results67670.0302233.3
 (SQL Overall)178691677.12325086.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.