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

496 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
holard1041057(None) 
hoard94918311ho_ard
holards1148431holards
board85523002bo_ard
bolar75123472bolar_
bollard103210502bollard
boyard125411282boyard
collard103712922collard
coward12411672coward
dotard839052dotard
foulard11257282foulard
goliard936072goliard
halyard1476972halyard
hard85443502h__ard
hazard1938402hazard
heard95222752h_eard
hilar85418142hilar_
hoar76729162ho_ar_
hoards104912622ho_ards
hoars85925542ho_ars
hoary114516762ho_ary
hodad10311352hoda_d
hold86235062hol__d
holed95634132hol_ed
holked144913662holked
hollaed11359852hollaed
holland11349472holland
horary12310382horary
lard56742002__lard
molar75223092molar_
molars85517322molars
polar75623452polar_
polars84419352polars
pollard103511142pollard
poulard10299732poulard
soland75115042soland
solar55927342solar_
tolar55524112tolar_
tolars64817922tolars
toward10311062toward
volar86917412volar_
aboard9312613aboard
afeard1058263afeard
aglare7312423aglare
ahold94714253ahol__d
aland65526413_aland
alar46340073_alar_
alarm76621423_alarm
alary86123443_alary
award97118043_award
bard75648863__bard
bayard124411663bayard
beard86024963_beard
belaud939133belaud
bland85320453_bland
blare75826233_blare
blared95018243_blared
boar66134293bo_ar_
boards94616933bo_ards
boars75229603bo_ars
boart78835933bo_art
bogart9617193bogart
bola66035563bola__
bolas74733763bola_s
bold75432813bol__d
bolero8412093bolero
bollards11339153bollards
bolled94722653bolled
bolted94617803bolted
bombard1437333bombard
boyar106013763boyar_
boyards13399323boyards
boyars115611983boyars
briard94311293briard
canard9314763canard
card710245873__card
chard116124743_chard
chola104718033chola__
cholas114817993chola_s
cholate122114933cholate
choler113717153choler_
cholera12409093cholera
cholers124215193cholers
chord115917263cho__rd
clad76225823_cla_d
claro75018693_claro
clary105719613_clary
coaled95022703coaled
coalyard1444083coalyard
cola66541393cola__
colas75436773cola_s
cold77338773col__d
colead94114643colead
coled85540753col_ed
collar83816173collar_
collards113310193collards
collared113211143collared
collars93816573collars
color76123743color_
colored10313473colored
colors86622373colors
colure8314153colure
cord76740923co__rd
costard104113353costard
covary1438743covary
cowards1339613cowards
doled75430913dol_ed
dollar74110983dollar_
dollars83311023dollars
dolled83518073dolled
dolor67617963dolor_
dolors75115313dolors
dotards937253dotards
dullard936603dullard
echard1249223echard
eland65820393_eland
fard85639063__fard
filar84819293filar_
flare84823633_flare
flared105317603_flared
foaled104515963foaled
folate93320393folate
fold86528943fol__d
folded114212793folded
foliar93210973foliar_
ford86835493fo__rd
forward1438293forward
foulards12266463foulards
froward1436673froward
glad65624013_gla_d
gland75217713_gland
glare65222953_glare
glared84715193_glared
glary96018543_glary
goad66830983go_a_d
goaled85014353goaled
goalward1343493goalward
gold65430163gol__d
goldarn944383goldarn
golfed11569763golfed
goliards1045133goliards
gonad75216053gona_d
gourd71011903go_urd
guard74415543_guard
gular6314833gular_
haar77323493h_aar_
haars85620473h_aars
had77658763h__a_d
haed86338583h__aed
haggard13377183haggard
halal85623593hala_l
halala94715093halala
halals95018313halals
halberd1336043halberd
haled95335823hal_ed
haler85033523haler_
halers94926913halers
haleru94212073haleru
halid94424973hal_id
halliard12125963halliard
haloed104717593haloed
haloid104317753haloid
halted105019603halted
halved134813903halved
halyards1576243halyards
hand86833703h__and
hards96435653h__ards
hardy125622063h__ardy
hare76255733h__are
hared95742183h__ared
hark115237393h__ark
harl75740003h__arl
harm95637793h__arm
harp96134283h__arp
hart76865773h__art
haulyard1583223haulyard
hayward1736413hayward
hazards2037463hazards
head87137173h_ea_d
healed105121443healed
hear76143883h_ear_
hears86737373h_ears
heart85440743h_eart
hegari1039513hegari
held85330403hel__d
helled104024703helled
helmed124513693helmed
helped124714153helped
helved134313703helved
herald10311343herald
herd84933063h__erd
hexad164910623hexa_d
hila76228353hila__
hilled104022223hilled
hilted104016043hilted
hoagy124710473ho_agy
hoarded12368343ho_arded
hoarder11329233ho_arder
hoarse94411323ho_arse
hoax147718293ho_a_x
hoaxed17378873hoaxed
hobbed144114303hobbed
hoboed124511683hoboed
hocked165521303hocked
hod76852463ho___d
hodaddy1642133hodaddy
hodads1147963hodads
hoed87837983ho__ed
hoer76533983ho_er_
hoers85724923ho_ers
hogan97817703hoga_n
hogans105914313hogans
hogged125817773hogged
hoised105117433hoised
hoked135326993ho_ked
holdall1145473holdall
holden104113953holden
holder104619653holder
holders113715903holders
holds94623243hol_ds
holdup1245183holdup
hole77553393hol__e
holes84748653hol_es
holey115626903hol_ey
holier94921623holier
holies94630033holies
holily123612953holily
holing104025073holing
holism113713743holism
holist94723213holist
holk116027943hol__k
holks124720563hol_ks
holla84918493hol_la
hollands12247273hollands
hollas94616903hollas
holler93520613holler
hollered1237603hollered
hollers103818233hollers
hollo84822163hol_lo
holloa94914823holloa
holloaed12157393holloaed
holloed113812753holloed
holloo94415253holloo
hollos95320633hollos
hollow124212663hollow
holly114824433hol_ly
holm95628103hol__m
holmic1338773holmic
holms105117803hol_ms
holp95727553hol__p
holpen11299413holpen
hols76946293hol__s
holt77852583hol__t
holts85627913hol_ts
holy106333433hol__y
homage121210603homage
homaged1497413homaged
hombre13309303hombre
homed115425423ho_med
homeland1446233homeland
homer105828453homer_
homered133212713homered
homers114821973homers
homeward1745323homeward
honan85319773hona_n
honans94814503honans
honed95332263ho_ned
honer85332093honer_
honers94324973honers
honied104818393honied
honked144517913honked
honor85718623honor_
honored11310123honored
honors94816793honors
hood85132333ho__od
hooded114616743hooded
hoofed134614893hoofed
hooked145320553hooked
hooped125518183hooped
hoorah124411113hoorah
hooray123011373hooray
hooted104422653hooted
hooved134713123hooved
hoped115628183ho_ped
hoper105829143hoper_
hopers114222973hopers
hopped144318113hopped
hora76136553ho__ra
horah117922043hora_h
horahs126313873horahs
horal86328673hora_l
horas86333093hora_s
horde94623053ho__rde
horded115420483horded
horn76735613ho__rn
horned105718703horned
horrid10311553horrid
horsed105321083horsed
hosed95830983ho_sed
hoser811529763hoser_
hosers95223953hosers
hosted105020343hosted
hotbed123310673hotbed
hotrod1048793hotrod
hotted104319933hotted
hound95016483ho_und
hour75827313ho_ur_
houri85915233ho_uri
hours85422383ho_urs
housed105624103housed
hover115524133hover_
hovered143411573hovered
hovers124320253hovers
howked177312343howked
howled134014963howled
howler123514313howler_
howlers133312353howlers
hoya107418373hoya__
hoyas115016163hoya_s
hula74923753hula__
hulas84920883hula_s
hulked144611303hulked
hulled103920013hulled
hyla106716513hyla__
hylas114815903hyla_s
inlaid7310133inlaid
inland7310313inland
inward10310333inward
island738533island
izzard15135243izzard
jeopard1744113jeopard
jolted143510633jolted
jowar155211433jowar_
jowars16369653jowars
kola85124963kola__
kolas94822233kola_s
lad48165703__la_d
laid56439143__laid
laird65417793__laird
land56337303__land
lar37967533__lar_
lards65331863__lards
lardy96119273__lardy
lari45839153__lari
lark85733863__lark
lars46956573__lars
laud56527723__laud
leopard1045293leopard
leotard846193leotard
liard65418593_liard
lizard16369233lizard
load56730603lo_a_d
lobar7313013lobar_
lolled74315823lolled
lord55032083__lord
lowland1134693lowland
lyard95113213_lyard
malar76424443malar_
malars85020683malars
mallard10310273mallard
mazard1838763mazard
milord999563milord
mola66035633mola__
molal75120343mola_l
molas75132093mola_s
mold76034333mol__d
molded104414083molded
molted94217473molted
monad85519473mona_d
monarda1046613monarda
mylar105311533mylar_
mylars114310443mylars
nard56634453__nard
nomad86016183noma_d
nonart6319193nonart
norland837163norland
notary92310713notary
oar37057953_o_ar_
oared65030653_o_ared
oars46846033_o_ars
old47033463_ol__d
onward1039053onward
orad56031693_ora_d
osar46820953_osar_
ovary1149113_ovary
pard76441323__pard
petard95013803petard
phylar14437373phylar_
pilar75221503pilar_
plaid85118303_plaid
pochard1537363pochard
polaron939843polaron
poled84934843pol_ed
poler74431793poler_
polers84225643polers
poleward1455943poleward
polkaed1435323polkaed
pollards11299523pollards
polled94022003polled
poniard1037583poniard
poplar103611113poplar_
poplars113910333poplars
poularde11276573poularde
poulards11288233poulards
regard85215773regard
relaid75518443relaid
reland75920433reland
retard75018933retard
reward106017633reward
ritard74812083ritard
road56332113ro_a_d
roar46328573ro_ar_
roared75015393ro_ared
roars55622233ro_ars
roband92310723roband
rolfed104510523rolfed
rolled74220243rolled
rosary92810353rosary
rotary92411303rotary
salad65321833sala_d
salary9515213salary
sard55344243__sard
scholar1236943scholar_
scholars1336673scholars
shard96125963_shard
shoaled113810963shoaled
shofar1236303shofar_
shofars1335813shofars
soar46838673so_ar_
soared74324293so_ared
soars54732513so_ars
sofar86115493sofar_
sofars94712783sofars
sola45541863sola__
solace83415823solace
solaced102911063solaced
solan55328153sola_n
solands84412343solands
solano65314183solano
solans64122493solans
solaria7312493solaria
solate64526073solate
solated83618023solated
sold54837413sol__d
soled65835173sol_ed
solid65025073sol_id
soloed74515743soloed
solved105312933solved
sonar56523423sonar_
sonars64818973sonars
sord56237203so__rd
souari6311373souari
sowar85821343sowar_
sowars94318003sowars
sward94221463_sward
tabard9313333tabard
talar56225383talar_
talars66021683talars
tholed105113873thol_ed
toad55830183to_a_d
togaed84711343togaed
tola45236333tola__
tolan55124013tola_n
tolane64316583tolane
tolans64319273tolans
tolas54532773tola_s
told56132203tol__d
toled65934923tol_ed
tolled73819033tolled
toluid738213toluid
towards1138783towards
troland837543troland
unlaid7311753unlaid
uphoard1344573upho_ard
upland938863upland
upward12147163upward
vaward13498723vaward
velar85817633velar_
velars93913723velars
visard103910123visard
vizard19458853vizard
volant9316323volant
voled95323723vol_ed
volery1237873volery
votary12248333votary
ward86542253__ward
wizard19377713wizard
woad85523943wo_a_d
woald94813073wo_ald
wold85429073wol__d
wolfed13428013wolfed
word89832003wo__rd
yard85633253__yard
yclad11246383ycla_d
yolked14367153yolked
zonary1838793zonary

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127164965.83019333.8
3Display Results4964960.1563179.5
 (SQL Overall)1786914966.10929250.5
 
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.