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

285 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
hoydens1434740(None) 
hoddens12378801hoddens
hoidens11329081hoidens
hoyden13328931hoyden_
codens94821012co_dens
doyens104810222doy_ens
hardens113815022hardens
heydeys1732862heydeys
hodden113811452hodden_
hoddins12289372hoddins
hoiden103612332hoiden_
holden104113952holden_
holders113715902holders
hordeins1238322hordeins
hordes104921632horde_s
hoydened1644642hoydened
hoydenish1942562hoydenish
hoyles12315012hoyle_s
hymens1437992h_ymens
lodens74315062lo_dens
loudens8368052loudens
soddens9348412soddens
bodes84935103bo_de_s
bonders104120663bonders
bordels103911973bordels
borders104317533borders
boreens9310403boreens
boudins10311313boudins
broadens11267233broadens
burdens1039713burdens
chortens13308793chortens
chowders17387533chowders
codders114114443codders
codecs115112933co_decs
codeins103715483co_deins
coden86128543co_den_
coders95426973co_ders
codes86247293co_de_s
codons96119463co_dons
condemns1336293condemns
condense1179613condense
copens106119963co_pens
corders104520873corders
cordons104415763cordons
covens114919263co_vens
coydogs1434493coydogs
coyness1277323coyness
cozens176314923co_zens
cyders12398833_cyders
deadens93410693deadens
dens55945073___dens
dodders105511793dodders
dolmens10388693dolmens
dovens104413903do_vens
doyen95014413doy_en_
doyleys14384923doyleys
dozens164612463do_zens
emydes1236173emyde_s
fodders124010753fodders
folders113514393folders
foyers125413133foy_ers
gardens93312093gardens
goddess1035263goddess
godets8410933go_dets
golden84411153golden_
gorhens1137183gorhens
guldens9356573guldens
hades96035113h_ade_s
hagdons1258523hagdons
handers114224333handers
happens14359173happens
haptens124511343haptens
harden105718533harden_
harkens144112863harkens
hastens106214813hastens
hausens1077633hausens
havens124514043h_avens
hayers124415943hay_ers
headend12398363headend
headends13326723headends
headers113819393headers
heavens13439303heavens
heders104119763h_eders
heeders114213743heeders
hens75642573h___ens
herders113914123herders
heydays1734143heydays
heydey1634633heyde_y
hidden11429743hidden_
hiders104919653h_iders
hides95129423h_ide_s
hinders113718503hinders
hoarders12307433hoarders
hoarsens11306023hoarsens
hoaxers17327133hoaxers
hoaxes163611693hoaxe_s
hobbers143512343hobbers
hoboes114717443hoboe_s
hockers163915913hockers
hockeys19509273hockeys
hodads1147963ho_dads
hoddin11369933hoddin_
hods87239863ho_d__s
hoedowns15124653hoedowns
hoers85724923ho__ers
hoes75755733ho__e_s
hogans105914313ho_gans
hoggers124512483hoggers
hoggets12498323hoggets
hoidened1335653hoidened
hoises94823673hoise_s
hokes126231643ho_ke_s
holder104619653holde_r
holding123514283holding
holdings13297743holdings
holds94623243hold__s
holdups1333593holdups
holes84748653ho_le_s
holies94630033holie_s
hollers103818233hollers
holpen11299413holpen_
holydays1843473holydays
homers114821973ho_mers
homes106938813ho_me_s
homeys145012873ho_meys
homies114524723homie_s
homines123518633homines
honans94814503ho_nans
hondas10313353hond_as
hondles113614523hondles
honers94324973ho_ners
hones88144493ho_ne_s
honeydews1941753honeydews
honeys124016083ho_neys
honkers143315233honkers
honkeys17439513honkeys
hons77350783ho___ns
hooded114616743hoode_d
hoodies113419833hoodies
hooding123815203hooding
hoodless12289733hoodless
hoodoos11109293hoodoos
hoods95124083hood__s
hooeys125512313ho_oeys
hoofers134513323hoofers
hookers144916513hookers
hookeys17448953hookeys
hoopers123616483hoopers
hooters104520463hooters
hoovers134312703hoovers
hooves124815483hoove_s
hopers114222973ho_pers
hopes105835643ho_pe_s
hoppers143115143hoppers
horde94623053horde__
horded115420483horde_d
hordein1138753hordein
hording123517053hording
hornets104113553hornets
horns86125333ho__rns
horrent10313553horrent
horses94729343horse_s
hosels94218603ho_sels
hosen85623883ho_sen_
hosers95223953ho_sers
hoses85443173ho_se_s
hoseys124614003ho_seys
hosiers104212633hosiers
hostels103712313hostels
hostess103210233hostess
hotbeds13315003hotbeds
hotdogs1234453hotdogs
hotels94515503ho_tels
hotness1038603hotness
houdahs1434243houdahs
hounders123111703hounders
housels105312133housels
housers104717813housers
houses96032273house_s
hovels125413333ho_vels
hovers124320253ho_vers
howdahs1733613howdahs
howdies142911953howdies
howes114730263ho_we_s
howlers133312353howlers
howlets13329223howlets
hoyas115016163hoy__as
hoydening1744353hoydening
hoyle11314413hoyle__
hoys107733933hoy___s
hyaena1235363h_yaena
hyaenas1334983h_yaenas
hydras13239313h_ydras
hydros13279363h_ydros
hyena11810253h_y_ena
hyenas1288953h_y_enas
hymen13311043h_ymen_
hymns1337523h_y_mns
hypers144811913h_ypers
hypes135818673h_ype_s
hyphens1836043hyphens
hysons1237633h_ysons
iodins74216513io_dins
jordans1566833jordans
joyless17226513joyless
ladens74516233_ladens
leadens83610983leadens
lindens839413lindens
loaders83413413loaders
loden66621143lo_den_
lodes66436913lo_de_s
loosens716310953loosens
louden73711793louden_
maddens11359753maddens
maidens10349663maidens
middens11379373middens
mildens10339933mildens
models94216353mo_dels
modems114610763mo_dems
moderns1037963mo_derns
modes85537413mo_de_s
molders103315553molders
mondes94322353monde_s
mordent10313993mordent
mordents1138813mordents
moreens939963moreens
morgens10310463morgens
nodders94410253nodders
nodes64633493no_de_s
noyades1136563noyade_s
odeons739023_o_deons
odes57243243_o_de_s
olden65114853_olden_
omens75618963_o_mens
opens76118553_o_pens
orders74315993_orders
ovens86217453_o_vens
oxygens1843163oxygens
oyers87620883_oy_ers
oyes74940133_oy_e_s
polders103617373polders
pollens93713303pollens
ponders103618843ponders
poteens92910883poteens
powders134111553powders
reddens9259783reddens
roadeos837403roadeos
rodent7519243ro_dent
rodents8611543ro_dents
rodeos75314503ro_deos
rodes614039083ro_de_s
rondels82510053rondels
rouens64814443ro_uens
rowens94515303ro_wens
saddens9309603saddens
shodden12265753shodden_
shortens11288983shortens
sodden84011513sodden_
softens10347623softens
soldans83210403soldans
solders83517773solders
sonders83820713sonders
sondes74922873sonde_s
soudans8309353soudans
sowens93613153so_wens
soybeans1343283soybeans
suddens9308783suddens
syrens94911993_syrens
tokens104711563to_kens
toyers95516333toy_ers
toyless10268713toyless
toyons95512133toy_ons
voduns1035053vo_duns
voiders11279823voiders
voudons1135313voudons
wardens113711903wardens
widens106212723_widens
wonders113315993wonders
wooden103610303wooden_
woodhens1534103woodhens
woolens10398843woolens
worsens104610263worsens
wovens12449833wo_vens
yens75832263__y_ens
yodels104610073yo_dels

Search took 9 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.1401276364.3
2DLD Change Limit1340272857.73317331.8
3Display Results2852850.1262261.9
 (SQL Overall)1786912857.99922339.2
 
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.