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

101 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
halyards157624(None) 
halyard1476971halyard_
haulyards1682831haulyards
ballyards1544992ballyards
bayards13379682ba_yards
coalyards1543522coalyards
haggards14366762haggards
halberds1435172halberds
halliards13104932halliards
haulyard1583222haulyard_
haywards1845872haywards
hazards2037462ha_zards
holards1148432hol_ards
kailyards1743202kailyards
kaleyards1773292kaleyards
lanyards1266392lanyards
mallards1138322mallards
tanyards1276182tanyards
alands75418373_al_ands
alarms85913053_al_arms
altars64518153_altar_s
awards107113453_a_wards
backyards2146533backyards
ballads104212913balla_ds
ballyard1445893ballyard_
barnyards1543493barnyards
bastards113310313bastards
bayard124411663ba_yard_
beeyards1444593beeyards
boatyards1543963boatyards
bollards11339153bollards
boyards13399323_boyards
calcars11312653calcar_s
canards10311203ca_nards
coalyard1444083coalyard_
collards113310193collards
dastards10278083dastards
dullards1045493dullards
farmyards1842813farmyards
gabbards1445753gabbards
galliards1194543galliards
galyacs1335273galya_cs
galyaks1534623galya_ks
goliards1045133goliards
haars85620473ha__ar_s
haftaras14136073haftaras
haggard13377183haggard_
halalas104214083hal_alas
halals95018313hal_a_ls
halberd1336043halberd_
halberts1335963halberts
halers94926913hal_er_s
halids104016133hal__ids
hallahs133912463halla_hs
halliard12125963halliard_
hallmarks1843543hallmarks
halmas117017893halma__s
haloids113012543hal_oids
halteres113414593halteres
halters104619803halter_s
halvahs16417533halva_hs
halvas124714173halva__s
halvers133311423halver_s
hangars114313483hangar_s
hards96435653h___ards
hatbands1446283hatbands
hayers124415943ha_yer_s
haylages1536013haylages
hayward1736413hayward_
hazard1938403ha_zard_
hoards104912623h__oards
holard10410573hol_ard_
hollands12247273hollands
kailyard1643503kailyard_
kaleyard1683573kaleyard_
laggards11307053laggards
lallands9338563lallands
laniards967313laniards
lanyard1167293lanyard_
lards65331863__l_ards
liards75212613__liards
lyard95113213__lyard_
malars85020683mal_ar_s
mallard10310273mallard_
mansards1148013mansards
manwards1447613manwards
mazards1937703ma_zards
mazzards1943943mazzards
paillards1244973paillards
placards1345813placards
pollards11299523pollards
saggards11397493saggards
salads75316963sal_a_ds
shipyards1842983shipyards
tabards10310383ta_bards
talars66021683tal_ar_s
tankards1366253tankards
tanyard1167183tanyard_
tiltyards1362583tiltyards
vawards14457573va_wards
yards95324613___yards

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.1701051123.5
2DLD Change Limit1461621017.44019645.4
3Display Results1011010.0761328.9
 (SQL Overall)1786911017.68623248.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.