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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

117 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
hayward173641(None) 
haywards1845871haywards
wayward1736051wayward
award97118042_a_ward
bayard124411662bay_ard
haggard13377182haggard
halyard1476972halyard
haywire1644742haywire
hazard1938402ha_zard
manward1349092manward
skyward1843862skyward
vanward1456942vanward
vaward13498722va_ward
aboard9312613_aboard
afeard1058263_afeard
airward1148133airward
aswarm11107913_aswarm
awards107113453_a_wards
aware86420023_a_ware
awkward1843183awkward
backward2048103backward
barware12610703barware
bastard103012423bastard
bayards13379683bay_ards
baywood1646443baywood
bedward1497473bedward
boyard125411283boy_ard
byword1535053_byword
canard9314763ca_nard
cityward1742943cityward
clayware1643933clayware
coward12411673_coward
dastard9279703dastard
daycare1355093daycare
daymare1375633daymare
daywork1845653daywork
eastward1244993eastward
forward1438293forward
froward1436673froward
gabbard1336553gabbard
gaydar1135503gaydar_
gaydars1235803gaydars
goalward1343493goalward
haar77323493ha__ar_
haars85620473ha__ars
haftara13136093haftara
haggards14366763haggards
halberd1336053halberd
halliard12125963halliard
halyards1576243halyards
hangar104114513hangar_
hangared1337573hangared
hangars114313493hangars
hard85443503h___ard
hardware1546283hardware
hatband1346823hatband
haulyard1583223haulyard
hawala12368913ha_wala
hawed126025423ha_w_ed
hawked174712673ha_wked
hayed125822013hay__ed
hayer114620243hay_er_
hayers124415943hay_ers
hayfork2043763hayfork
haylage1436443haylage
hayrack1945543hayrack
hayseed1435633hayseed
haywires1744043haywires
hazards2037463ha_zards
headword1645523headword
heard95222753h__eard
hoard94918313h__oard
holard10410573h_olard
homeward1745323homeward
inward10310333_inward
jaybird2043123jaybird
jaywalk2442523jaywalk
keycard1743663keycard
keyword1844563keyword
laggard10347623laggard
landward1345823landward
laniard868523laniard
lanyard1167293lanyard
leeward1135783leeward
lyard95113213_ly_ard
mallard10310273mallard
mansard1049313mansard
manwards1447613manwards
maybird1543993maybird
mayweed1634163mayweed
mazard1838763ma_zard
mazzard1844463mazzard
naysaid1145313naysaid
onward1039053_onward
outward11811403outward
psywar1443323psywar_
psywars1533673psywars
rearward1245783rearward
reward106017643_reward
reynard1135123reynard
saggard10358953saggard
seaward1148183seaward
skywards1943373skywards
steward1138063steward
sunward1137653sunward
sward94221463__sward
tabard9313333ta_bard
tankard1267263tankard
tanyard1167183tanyard
toward10311063_toward
upward12147163_upward
vawards14457573va_wards
ward86542253___ward
waylaid1445093waylaid
waywardly2251883waywardly
wayworn1675293wayworn
yard85633253__y_ard

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271176.87619492.0
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.32824384.7
 
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.