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

95 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
tanyards127618(None) 
lanyards1266391lanyards
tankards1366251tankards
tanyard1167181tanyard_
barnyards1543492barnyards
bayards13379682ba_yards
canards10311202can_ards
halyards1576242halyards
laniards967312laniards
lanyard1167292lanyard_
mansards1148012mansards
manwards1447612manwards
standards1145202standards
tabards10310382ta_bards
tanbarks1445562tanbarks
tankard1267262tankard_
tantaras8269542tantaras
anears63717183_anear_s
awards107113453_a_wards
backyards2146533backyards
ballyards1544993ballyards
bankcards1873783bankcards
banyans1237913banya_ns
barnyard1443783barnyard_
bastards113310313bastards
bayard124411663ba_yard_
beeyards1444593beeyards
boatyards1543963boatyards
boneyards1584623boneyards
boyards13399323_boyards
canard9314763can_ard_
coalyards1543533coalyards
dastards10278083dastards
fanfares1436773fanfares
farmyards1842813farmyards
flancards1543183flancards
gabbards1445753gabbards
haggards14366763haggards
halyard1476973halyard_
hangars114313493hangar_s
haulyards1682833haulyards
haywards1845873haywards
hazards2037463ha_zards
innards837153_innards
inwards1138343_inwards
junkyards2441573junkyards
kailyards1743203kailyards
kaleyards1773293kaleyards
kantars11310033kantar_s
laggards11307053laggards
landwards1445503landwards
laniard868523laniard_
mallards1138323mallards
mansard1049313mansard_
manward1349093manward_
mazards1937703ma_zards
mazzards1943943mazzards
nards65928463__n_ards
onwards1137173_onwards
poniards1145823poniards
reynards1244303reynards
saggards11397493saggards
sangars83116253sangar_s
sansars73313913sansar_s
staggards1244123staggards
standard1046253standard_
stinkards1443563stinkards
sunwards1236443sunwards
tabard9313333ta_bard_
tagboards1345133tagboards
talars66021683ta_lar_s
tamaris9413593ta_maris
tanbark1337373tanbar_k
tangrams1136163tangrams
tankages13217113tankages
tankas104613763tanka__s
tankers113416913tanker_s
tannages9228963tannages
tannates81911953tannates
tanners74018393tanner_s
tantalus836373tantalus
tantara72410823tantar_a
tantras73112093tan_tras
tartars73313403tartar_s
tatars64619793ta_tar_s
teaboards1245393teaboards
tiltyards1362593tiltyards
tinwares1137913tinwares
tonearms1044713tonearms
towards1138783t_owards
vanguards1443273vanguards
vanward1456943vanward_
vawards14457573va_wards
vineyards1643223vineyards
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 Limit146162957.34619896.8
3Display Results95950.0462065.2
 (SQL Overall)178691957.56223630.1
 
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.