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

85 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
hoydened164464(None) 
hoidened1335651hoidened
hardened1338612hardened
hoyden13328932hoyden__
hoydens14347402hoyden_s
loudened1044692loudened
soddened1144642soddened
bordered1248933bordered
broadened1364333broadened
burdened1236423burdened
chowdered1944013chowdered
condemned1545103condemned
condensed1387113condensed
condoned122612023condoned
convened143412223convened
cordoned12229613cordoned
cozened19349183co_zened
deadened1137233deadened
doddered1234943doddered
dovened12389063do_vened
dozened18377453do_zened
foddered1434553foddered
gardened1137003gardened
goldener1045403goldener
happened1635653happened
hardener1238883hardener
harkened1637483harkened
hastened12239103hastened
havened14429243h_avened
hayseed1435633hayse_ed
headend12398363headen_d
hindered1339453hindered
hoarsened1344053hoarsened
hodden113811453hodden__
hoddens12378803hodden_s
hogweed1534443hogwe_ed
hoiden103612333hoiden__
hoidens11329083hoiden_s
holden104113953holden__
hollered1237603hollered
homered133212713ho_mered
hondled123510653hond_led
honed95332263ho___ned
honeyed1437773ho_neyed
hooded114616743hood__ed
hoodooed1344963hoodooed
hoovered15195413hoovered
horded115420483hord__ed
horned105718703ho__rned
hoseyed1436953ho_seyed
hosteled1237293hosteled
houseled1237283houseled
hoveled14209293ho_veled
hovered143411573ho_vered
howdied15296843howd_ied
hoydening1744353hoydening
hoydenish1942563hoydenish
hymned1535323h_y_mned
hyphened2044693hyphened
ladened979053_ladened
leadened1036153leadened
loosened945453loosened
maddened1334893maddened
mildened1235773mildened
modeled1139463mo_deled
modemed1336723mo_demed
moldered1237173moldered
omened93711003_o_mened
opened94311863_o_pened
ordered9108533_ordered
pollened1157783pollened
pondered126411293pondered
powdered15256893powdered
reddened1136423reddened
rodeoed937883ro_deoed
saddened1135343saddened
shortened1345663shortened
softened1235663softened
soldered1038153soldered
tokened1236393to_kened
widened12328053_widened
wondered13239943wondered
woodener1245763woodener
worsened1236053worsened
yodeled1236863yo_deled

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.406440125.6
2DLD Change Limit146162857.17020385.2
3Display Results85850.0332575.8
 (SQL Overall)178691857.60923484.2
 
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.