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

87 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
daymare137563(None) 
daycare1355091daycare
daymares1445331daymares
damage10410782da_mage
damar84117742da_mar_
damars93815002da_mars
dammar11438902dammar_
dammars12308192dammars
daycares1454802daycares
admire949933_admire
aglare7312433_aglare
amaze166016603_a_maze
anymore1256243anymore
armure8710133_armure
aware86420023_a_ware
barware12610703barware
bayard124411663bay_ard
bayman133712703bayma_n
carfare12310073carfare
caviare1238373caviare
cayman133613213cayma_n
caymans14349513caymans
claymore1544263claymore
clayware1643933clayware
cymae126713013_cyma_e
cymar125711263_cymar_
cymars13599153_cymars
damaged1257463da_maged
damager1157983da_mager
damages11511283da_mages
daman84821163da_ma_n
damans94715983da_mans
damask1335843da_mask
dame77140313da_m__e
dammer114317933dammer_
dammers123214273dammers
damner95213433da_mner
damper114117753da_mper
darbar959953darbar_
darbars10510093darbars
dare55848863d___are
dastard9279703dastard
dasyure1153823dasyure
datary10310243da_tary
dayside1236173dayside
daysman1335053daysma_n
daystar1143443daystar_
daystars1243903daystars
daytime1344783daytime
daywork1845653daywork
decare93919153d_ecare
deciare10710663deciare
declare10411223declare
dekare112811563d_ekare
demark134211023d_emark
demure9311533d_emure
drayage1234433dray_age
drayman1335433drayma_n
earmark1345653earmark
fanfare1336673fanfare
gaydar1135503gaydar_
gaydars1235803gaydars
hamate113319833ha_mate
haylage1436443haylage
haymaker20104773haymaker
hayward1736413hayward
haywire1644743haywire
layman113511303layma_n
mammae94613213mamma_e
mammary1335993mammary
mammate104411273mammate
manmade1237963manmade
mare64759333___mare
palmar104113463palmar_
palmary14338553palmary
palmate113215233palmate
playmate1566463playmate
ramate83921693ra_mate
samara8313853sa_mara
tamale83717403ta_male
tamari8313413ta_mari
tartare73012683tartare
warfare1336733warfare
wayfarer1742923wayfarer
wayward1736053wayward
yare75636943__y_are
zymase201997483_zymase

Search took 7 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 Filter1786911340270.406440125.6
2DLD Change Limit134027876.28021341.9
3Display Results87870.0332636.4
 (SQL Overall)178691876.71926594.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.