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

71 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
mercy12591618(None) 
merc87225621merc_
merch125417961merch
mercs96020451mercs
merry104721481merry
aery77231682aer_y
amerce10310512amerce
berry104521762berry
cerci93716392cerci
decry115514352decry
deray95024182deray
derby114715342derby
derry94721372derry
eery76129622eer_y
emery104814332emer_y
farcy135217092farcy
ferly115517352ferly
ferny115816182ferny
ferry116020802ferry
germy115113662germy
herby134715312herby
herry114922472herry
jerky196712422jerky
jerry155016182jerry
kerry124916092kerry
marc87034622marc_
march125622892march
marcs95726622marcs
marly106925612marly
marry104821692marry
marvy135014032marvy
mealy104422182mealy
meany104620472meany
meaty107021312meaty
mecca1139932mecca
meiny104015402meiny
melty104918362melty
mercer105214202mercer
mercery14397622mercery
merces105720742merces
mercury14364892mercury
merde84320122merde
mere67244442mer_e
merely111312582merely
merer75126232merer
meres75143572meres
merge84523682merge
merit7339182merit
merk106027942mer_k
merks114722402merks
merl65830972mer_l
merle75824372merle
merls77423902merls
meshy135612782meshy
messy104913832messy
mincy125817412mincy
mirky146315522mirky
miry96326742mir_y
moray105423792moray
murky145216682murky
murry105120232murry
nerdy95014702nerdy
nervy114610862nervy
perch124518832perch
perdy115417322perdy
perky145319482perky
perry105222712perry
serry84824122serry
terce75721842terce
terry84721872terry
very108025642ver_y

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.1731032896.0
2DLD Change Limit53800712.48321667.3
3Display Results71710.0164437.5
 (SQL Overall)178691712.67266875.4
 
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.