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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

115 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
mesially1311908(None) 
medially14129321medially
menially131111091menially
mesally12119791mes_ally
mesically16310091mesically
aerially11911912aerially
bestially1447052bestially
festally1437542festally
genially12129522genially
medianly14125942medianly
medically17310112medically
mentally131010402mentally
mesial84818082mesia_l_
mesnalty1343422mesnalty
misally121111062mis_ally
musically1647852musically
serially11912842serially
venially1499422venially
vestally1437412vestally
axially1737233_axially
basally1237963bas_ally
basically1648033basically
casually1356823casually
cecally1459393ce_cally
costally1339733costally
decimally1745613decimally
deniably1448553deniably
dentally121110063dentally
desirably1546633desirably
dismally1446513dismally
distally1239553distally
emetically17411423emetically
epically15310583_epically
equally1936873_equally
evilly1236593_evi_lly
facially1637643facially
feudally1554823feudally
filially1447003filially
fiscally1646073fiscally
geminally1576403geminally
genically151110173genically
genitally13127173genitally
helically1749433helically
imperially1746843imperially
jovially2144753jovially
labially1336983labially
leally94012613le__ally
legally1138133le_gally
lethally1445923lethally
lexically2146773lexically
magically1748963magically
manically16311703manically
manually1347043manually
maritally1448233maritally
martially1448183martially
materially1548003materially
maximally2344393maximally
mealy104422183me__a_ly
meanly115412043me__anly
measly113610443me__asly
mediacy1536143media_cy
medial93819863media_l_
medials103914733media_ls
mediately1544613mediately
medievally1952573medievally
megilla1036273megi_lla
memorially1745653memorially
menial84223033menia_l_
menials94015683menia_ls
mescal104113493mesca_l_
mescals112911563mesca_ls
mesian84315503mesia__n
messily12298813mes_sily
metrically17411083metrically
minimally1645903minimally
miscall1139653miscall_
miscalls1239003miscalls
modally1338403m_odally
morally12411493m_orally
mortally1339933mortally
mosaically1747423mosaically
musingly1436433musingly
mutually1345203mutually
mystically2048123mystically
nasally1057443nas_ally
neurally1137933neurally
oedipally1543903oedipally
penally121111773pe_nally
postally13310273postally
racially1339623racially
radially1239783radially
rascally1347733rascally
really93315613re__ally
rectally1339713rectally
regally1159873re_gally
reliably1339243reliably
remedially1644373remedially
residually1453043residually
retally10413683re_tally
retrally11310523retrally
sally85129713__s_ally
seminally1458803seminally
sensually1245313sensually
sexually1845603sexually
silly84527623__si_lly
socially1338543socially
specially1647343specially
telically1449853telically
uncially1339073uncially
usually1066063_usually
venally13119563ve_nally
verbally1647183verbally
vernally1447823vernally
visually1465493visually
xerically2149533xerically

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.436409841.7
2DLD Change Limit1461621157.25320151.9
3Display Results1151150.0432674.4
 (SQL Overall)1786911157.73223110.6
 
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.