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 “mattin” 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
mattin8441663(None) 
lattin64316221lattin
martin84122521martin
matin75132851ma_tin
matting103620141matting
mattins93316141mattins
actin74922552_actin
attain6311752_attain
attic75618352_attic
batten85217122batten
battik1238092battik
batting104422272batting
catkin123512382catkin
catlin83819082catlin
cattie85221022cattie
catting103922642catting
fatten94314902fatten
fatting113818702fatting
gittin72910552gittin
hatpin112610612hatpin
hatting113920232hatting
latten65018202latten
lattins74115482lattins
maftir1136492maftir
main65345522ma__in
malkin122913152malkin
malting103219082malting
mantic104120902mantic
mantid93820382mantid
mantis83926032mantis
margin94016852margin
marlin84220902marlin
marten84518262marten
martian93514682martian
marting103325012marting
martini93613872martini
martins93322062martins
mastic103119172mastic
masting104325822masting
mastix152310512mastix
mating94832912ma_ting
matins84527782ma_tins
matrix1539852matrix
matron83918312matron
matt65752662matt__
matte75626842matt_e
matted94521412matted
matter84325342matter
mattes85624532mattes
mattings11369672mattings
mattoid1079282mattoid
matts76829182matt_s
mavin105722952ma_vin
mayvin1436522mayvin
mitten83914092mitten
muntin82915182muntin
mutton8510452mutton
patin76832852pa_tin
patten84418192patten
pattie84020962pattie
patting103722342patting
ratlin64116522ratlin
rattan63613602rattan
ratten64217382ratten
ratting83822362ratting
ratton64116122ratton
satin55935222sa_tin
statin63921472statin
tattie64817512tattie
tatting84019522tatting
vatting113614852vatting

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 Filter178691825510.343520965.0
2DLD Change Limit82551712.56332208.7
3Display Results71710.0302366.7
 (SQL Overall)178691712.93660862.1
 
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.