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

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

121 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
hatred10481433(None) 
haired105117171haired
hared95742181ha_red
hated95734021hat_ed
hatreds11307811hatreds
hatted104921511hatted
acred87126352_acred
aired66032922_aired
bared85144482ba_red
barred95725792barred
bated85935532bat_ed
bathed125518742bathed
batted95623652batted
cared86050092ca_red
carted98631442carted
catered103117772catered
catted95422472catted
chaired134211242chaired
chared125423692cha_red
charred134614482charred
charted135116852charted
chatted133411892chatted
dared75935012da_red
darted84620922darted
dated75530992dat_ed
eared65139502ea_red
faired105915772faired
fared95842342fa_red
farted105121782farted
fated95632132fat_ed
fatted105419842fatted
garred85217412garred
gated75329772gat_ed
hacked164923512hacked
haded105227622ha_ded
haed86338582ha__ed
haeres94017032haeres
hafted134713832hafted
hagged124317702hagged
hailed104122742hailed
haled95335822ha_led
haloed104717602haloed
halted105019602halted
haltered123112562haltered
halved134813902halved
hammed144116972hammed
handed114919982handed
hanged114222392hanged
hanked144220602hanked
hanted104124312hanted
happed144820102happed
hard85443502ha_r_d
hare76255732ha_re_
harem104924452ha_rem
hares86255542ha_res
harked145422552harked
harmed125218832harmed
harped124418402harped
harried113815532harried
hashed136021942hashed
hasped125014442hasped
hasted105125282hasted
hatched163414462hatched
hate78450172hat_e_
hater85034752hat_er
haters94930402haters
hates86742572hat_es
hatter94724872hatter
hauled104415212hauled
havered144011452havered
hawed126025422ha_wed
hawked174712672hawked
hayed125822012ha_yed
hazed185222202ha_zed
hearted113314022hearted
heated104525592heat_ed
heired103813042heired
hired95226262h_ired
hotbed123310682hotbed
hotrod1048802hotrod
hotted104319942hotted
hutted104616332hutted
jarred144613252jarred
laired75216812laired
lated65240672lat_ed
lathed104718462lathed
marred95421042marred
marted94425212marted
mated85537782mat_ed
matres84522232matres
matted94521412matted
matured10310042matured
metred95315142metred
mitred94414342mitred
nacred95212492nacred
natured838962natured
oared65030652oa_red
paired95017522paired
pared86946762pa_red
parred95024072parred
parted94228682parted
pated85237842pat_ed
patted94724682patted
rared65738322ra_red
rated65441382rat_ed
ratted74923342ratted
sabred95916532sabred
sacred94917102sacred
sated66238532sat_ed
shared105829062sha_red
stared75429872stared
tared69340052ta_red
tarred74720282tarred
tarted74923372tarted
tatted74920532tatted
vatted104214732vatted
waired106015832waired
wared96339872wa_red
warred104019842warred
warted104223232warted
watered113014952watered

Search took 4 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 Filter178691825510.393454684.5
2DLD Change Limit825511212.90328436.4
3Display Results1211210.0502420.0
 (SQL Overall)1786911213.34653404.4
 
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.