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

69 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
daymares144533(None) 
daycares1454801daycares
daymare1375631daymare_
damages11511282da_mages
damars93815002da_mar_s
dammars12308192dammar_s
daycare1355092daycare_
admires1038663_admires
amazes175613473_a_mazes
armures9510273_armures
barwares13610093barwares
bayards13379683bay_ards
camases114216343ca_mases
carfares13310323carfares
caviares1337993caviares
caymans14349513cayma_ns
claymores1644283claymores
claywares1743463claywares
cymars13599153_cymar_s
daemones11209163daemones
daimones11208803daimones
damage10410783da_mage_
damaged1257463da_maged
damager1157983da_mager
damagers1237073da_magers
damans94715983da_ma_ns
damar84117743da_mar__
damasks1435073da_masks
dames85435853da_m__es
dammar11438903dammar__
dammers123214273dammer_s
damners104112113da_mners
dampers123915693da_mpers
darbars10510093darbar_s
dares66146703d___ares
dastards10278083dastards
dasyures1254153dasyures
dataries9314033da_taries
dayflies1534463dayflies
daysides1335963daysides
daystars1243903daystar_s
daytimes1434483daytimes
dayworks1945563dayworks
decares102818533d_ecares
deciares11510633deciares
declares11611313declares
dekares122710873d_ekares
demarks14339233d_emarks
dolmades1245463dolmades
drayages1344513dray_ages
dryades12395633dry_ades
earmarks1444793earmarks
fanfares1436773fanfares
gaydars1235803gaydar_s
hamates122917683ha_mates
haylages1536013haylages
haymaker20104773haymaker
haymakers21104553haymakers
haywards1845873haywards
haywires1744043haywires
mares76457633___mares
playmates1646603playmates
samaras9312913sa_maras
tamales93216153ta_males
tamaris9413603ta_maris
warfares1436683warfares
wayfarer1742923wayfarer
wayfarers1842623wayfarers
zymases21938333_zymases

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.406440125.6
2DLD Change Limit146162697.47019566.5
3Display Results69690.0302300.0
 (SQL Overall)178691697.90622601.9
 
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.