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

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

148 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
mealy10442218(None) 
meal65643171meal_
meals75933371meals
meanly115412041meanly
meany104620471meany
measly113610441measly
meaty107021311meaty
vealy115817771vealy
beady114719922beady
beaky146118022beaky
beamy126218572beamy
belay105021522belay
belly104625492belly
bialy105119322bialy
coaly105521592coaly
deadly113811472deadly
deafly13389122deafly
deal56347412deal_
deals65435342deals
dealt65234282dealt
dearly104615322dearly
deary95826842deary
delay94820632delay
delly96023872delly
early85324122_early
easy76224492_easy
eely77725212_eely
feal713940422feal_
fealty122910222fealty
featly123711752featly
felly114922802felly
ferly115517352ferly
feyly14429512feyly
heady125117262heady
heal75645692heal_
heals85733452heals
heapy135914982heapy
heavy144814182heavy
jelly154218252jelly
kelly124617022kelly
leady95618602leady
leafy116316212leafy
leaky125217722leaky
leal46043272leal_
leally94012612leally
lealty92910602lealty
leanly93811502leanly
leary85927382leary
leavy115715772leavy
madly115218132madly
male66052292m_ale
mall64639362m_all
malm85129972m_alm
malmy124816342m_almy
malt66254802m_alt
malty106721702m_alty
manly105022942manly
many95731842m_any
marly106925612marly
may88757622m_a_y
mazy186419692m_azy
mead75531602mea_d
meads85425322meads
mealie82519802mealie
mean65538082mea_n
means75831222means
meant76537202meant
measle83513222measle
meat66359602mea_t
meatily12311092meatily
meats75034052meats
medal86221322medal_
medals94218042medals
medfly1535222medfly
medley1298332medley
meekly1535192meekly
meetly1138672meetly
meiny104015412meiny
mel56047482me_l_
meld75830472me_ld
mell64935612me_ll
mells75031332mells
mels65941532me_ls
melt65752892me_lt
melty104918362melty
mercy125916182mercy
merely111312582merely
merl65830972merl_
merle75824372merle
merls77423902merls
merry104721482merry
mesally12119792mesally
meshy135612782meshy
messy104913832messy
metal75427382metal_
metals84520882metals
mewl95618322mewl_
mewls105813232mewls
molly105222492molly
moly96031912m_oly
muhly1358522muhly
nearly94813732nearly
neatly93812482neatly
nelly84618812nelly
newly114610202newly
paly95835532_paly
peaky145718152peaky
peal68648102peal_
peals75235492peals
pearly116414842pearly
peaty105725692peaty
peavy135014842peavy
ready94821502ready
real45750292real_
really93315612really
realm75621622realm
reals55038652reals
realty92713692realty
redly94217192redly
refly113914562refly
relay84424672relay
rely75428952re_ly
reply104015852reply
scaly104718722scaly
seal45654372seal_
seals54839692seals
seamy105921272seamy
seely84522632seely
shaly114322862shaly
smeary114110802smeary
smelly114110352smelly
teal45546502teal_
teals56234132teals
teary85124052teary
telly84920822telly
veal76936812veal_
veals84926192veals
waly105830902_waly
weakly1636482weakly
weal75838682weal_
weald95615022weald
weals85428742weals
weary115620612weary
welly114620012welly
wetly114511712wetly
yearly125210272yearly
zeal135530332zeal_
zeals145320852zeals

Search took 3 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.1101624463.6
2DLD Change Limit538001481.93627789.3
3Display Results1481480.0463217.4
 (SQL Overall)1786911482.09285416.3
 
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.