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

128 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
tanyard116718(None) 
lanyard1167291lanyard
tankard1267261tankard
tanyards1276181tanyards
barnyard1443782barnyard
bayard124411662ba_yard
canard9314762can_ard
halyard1476972halyard
laniard868522laniard
lanyards1266392lanyards
mansard1049312mansard
manward1349092manward
standard1046252standard
tabard9313332ta_bard
tanbark1337372tanbark
tankards1366252tankards
tantara72410822tantara
vanward1456942vanward
aboard9312613_aboard
afeard1058263_afeard
anear55420323_anear_
aneared8512743_aneared
anears63717183_anears
angary10311323_angary
award97118043_a_ward
backyard2046843backyard
ballyard1445893ballyard
bandaid11310483bandaid
bankcard1774023bankcard
banyan1139483banya_n
banyans1237913banyans
barnyards1543493barnyards
bastard103012423bastard
bayards13379683ba_yards
beeyard1335523beeyard
boatyard1444073boatyard
boneyard1475323boneyard
boyard125411283_boyard
canards10311203can_ards
canary11314693can_ary
coalyard1444093coalyard
dastard9279703dastard
fanfare1336673fanfare
farmyard1742833farmyard
flancard1443373flancard
gabbard1336553gabbard
haggard13377183haggard
halyards1576243halyards
hangar104114513hangar_
hangared1337573hangared
hangars114313493hangars
haulyard1583223haulyard
hayward1736413hayward
hazard1938403ha_zard
inward10310333_inward
junkyard2341753junkyard
kailyard1643503kailyard
kaleyard1683573kaleyard
kantar10311153kantar_
kantars11310033kantars
laggard10347623laggard
landward1345823landward
laniards967313laniards
laniary1068013laniary
lyard95113213__lyard
mallard10310273mallard
mansards1148013mansards
manuary1237773manuary
manwards1447613manwards
mazard1838763ma_zard
mazzard1844463mazzard
nard56634453__n_ard
onward1039053_onward
poniard1037583poniard
reynard1135123reynard
saggard10358953saggard
sangar73617683sangar_
sangars83116253sangars
sansar63613393sansar_
sansars73313913sansars
staggard1144513staggard
standards1145203standards
stannary1144613stannary
stanzaed1843873stanzaed
stinkard1344323stinkard
sunward1137653sunward
tabards10310383ta_bards
tagboard1245563tagboard
talar56225383ta_lar_
talars66021683ta_lars
tamari8313403ta_mari
tanbarks1445563tanbarks
tanga64923693tanga__
tanged84622493tan_ged
tangled94214633tangled
tangoed9318833tangoed
tangram1038073tangram
tanka93817483tanka__
tankage12257773tankage
tankas104613763tanka_s
tanked113919293tan_ked
tanker104521123tanker_
tankers113416913tankers
tannage8209583tannage
tannate71813523tannate
tanned75219953tan_ned
tanner63722283tanner_
tanners74018393tanners
tannery10388663tannery
tantaras8269543tantaras
tantra63713353tan_tra
tantras73112093tantras
tartar63214753tartar_
tartare73012683tartare
tartars73313403tartars
tatar56122063ta_tar_
tatars64619793ta_tars
taxpaid1743093taxpaid
teaboard1146293teaboard
tiltyard1262933tiltyard
tinware1038603tinware
tonearm937443tonearm
toward10311063t_oward
vanguard1343893vanguard
vaward13498723va_ward
vineyard1543983vineyard
wayward1736053wayward
yard85633253___yard

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 Limit1340271286.45320769.7
3Display Results1281280.0462782.6
 (SQL Overall)1786911286.90525878.5
 
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.