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

86 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
meiny10401541(None) 
meany104620481meany
veiny115414361veiny
beigy111110582beigy
being84920502being
benny105217362benny
briny104719662briny
deify124112762deify
deity94316772deity
deny86027122de_ny
feint84732252feint
fenny115115132fenny
ferny115816182ferny
jenny153811622jenny
liny78141332_liny
main65345522main_
mainly11411492mainly
mains75635112mains
many95731862m_any
mealy104422182mealy
mean65538092mean_
meanly115412042meanly
means75831232means
meant76537212meant
meaty107021312meaty
medina94114092medina
meinie82614522meinie
melty104918362melty
men59252852me_n_
mend75334032me_nd
meninx1538702meninx
meno66031362me_no
menu65130232me_nu
mercy125916182mercy
merino8315092merino
merry104721492merry
meshy135612782meshy
mesne75116292mesne
messy104913832messy
meting94320592meting
mewing123914202mewing
mien65028372mien_
miens76118302miens
mina65136932m_ina
mincy125817412m_incy
mind75434392m_ind
mine67256182m_ine
mingy115520182m_ingy
mini65634572m_ini
mink106636542m_ink
minny104518662minny
mint66758072m_int
minty106323902m_inty
minx137723362m_inx
miry96326762m_iry
mity95528222m_ity
mony96830012m_ony
moony104818272moony
mutiny113612682mutiny
pein65834942pein_
peins76128062peins
penny105119452penny
peony105717562peony
piny911838362_piny
rainy85921082rainy
reify114814972reify
rein46040892rein_
reink95518092reink
reins56234562reins
resiny94617362resiny
seine55732872seine
shiny115122142shiny
spiny104921302spiny
teeny85417882teeny
teind6213612teind
tiny76134642_tiny
twiny116012812twiny
vein75625752vein_
veins84620492veins
viny106025962_viny
weeny115316162weeny
wenny114412462wenny
whiny144915572whiny
winy107034332_winy
zein135620602zein_
zeins144715392zeins

Search took 4 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 Filter178691538000.610292936.1
2DLD Change Limit53800862.53021264.8
3Display Results86860.0302866.7
 (SQL Overall)178691863.17056369.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.