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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

64 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
muscatel124606(None) 
muscadel1343761muscadel
muscatels1343441muscatels
moschatel1643202moschatel
muscadels1442622muscadels
muscadet1348142muscadet
muscae10410672musca_e_
muscat10314662muscat__
muscats1138932muscat_s
brocatel1246713brocatel
cascabel14174503cascabel
cuspate1138233cuspate_
cuspated1335913cuspated
furcate12310453furcate_
furcated1437593furcated
furcately1742913furcately
furcates1339883furcates
mescal104113493mesca__l
misacted1338673misacted
misate81222693mis_ate_
miscall1139653misca_ll
miscite11314383miscite_
miscited13310423miscited
miscites12313783miscites
misdate101413963misdate_
misdated121211123misdated
misdates111113633misdates
miseaten10310773miseaten
mislabel1296173mislabel
mismate111415353mismate_
mismated131111333mismated
mismates121114563mismates
misrate91319143misrate_
misrated111315383misrated
misrates101318243misrates
moschate1546593moschate_
moschatels1752093moschatels
mudcat11311203mudcat__
mudcats1236223mudcat_s
mulcted12296693mulc_ted
muriate9313363muriate_
muriated1139793muriated
muriates10312093muriates
muricate12311113muricate_
muricated1448243muricated
musca9311763musca___
muscadets1442963muscadets
muscle10310973musc_le_
muscled1237783musc_led
muscles11310563musc_les
musette938433musette_
musettes1037433musettes
musical1139553musica__l
musicale1247343musicale_
musicales1346703musicales
mussel83412903mus__sel
musted93321073mus__ted
mustee83922103mus__tee
muster84724523mus__ter
mutate83017483mu_tate_
mutated102712253mu_tated
mutates92215793mu_tates
sulcate9314423sulcate_
sulcated11310373sulcated

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.420425454.8
2DLD Change Limit146162647.31319986.6
3Display Results64640.0331939.4
 (SQL Overall)178691647.76623009.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.