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

305 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
holards114843(None) 
hoards104912621ho_ards
holard10410571holard_
boards94616932bo_ards
bollards11339152bollards
boyards13399322boyards
collards113310192collards
cowards1339612cowards
dotards937252dotards
foulards12266462foulards
goliards1045132goliards
halyards1576242halyards
hards96435652h__ards
hazards2037462hazards
hoard94918312ho_ard_
hoars85925552ho_ar_s
hodads1147962hoda_ds
holds94623242hol__ds
hollands12247272hollands
lards65331862__lards
molars85517322molar_s
polars84419352polar_s
pollards11299522pollards
poulards11288232poulards
solands84412342solands
tolars64817942tolar_s
towards1138782towards
aholds10469483ahol__ds
alands75418373_alands
alarms85913053_alarms
awards107113453_awards
bards87139643__bards
bayards13379683bayards
beards94116673_beards
belauds1036643belauds
blares85021633_blares
board85523003bo_ard_
boars75229603bo_ar_s
boarts84716873bo_arts
bogarts1047743bogarts
bolar75123473bolar__
bolas74733763bola__s
bolases93315003bolases
bolds85825283bol__ds
boleros9310293boleros
bollard103210503bollard_
bombards1536493bombards
boyard125411283boyard_
boyars115611983boyar_s
briards10398553briards
canards10311203canards
cards85137933__cards
chards125119733_chards
cholas114818003chola__s
cholates132414763cholates
choleras13289043choleras
cholers124215203choler_s
chords125214633cho__rds
clads85722733_cla_ds
claros84015113_claros
coalyards1543533coalyards
colas75436773cola__s
colds85726973col__ds
coleads102911423coleads
collard103712923collard_
collars93816573collar_s
coloreds1138093coloreds
colors86622373color_s
colures9315143colures
cords86030623co__rds
costards113510803costards
coward12411673coward_
dollars83311023dollar_s
dolors75115313dolor_s
dotard839053dotard_
dullards1045493dullards
echards1337963echards
elands74914773_elands
fards96629843__fards
flares94521703_flares
folates103218453folates
folds95221693fol__ds
fords95328183fo__rds
forwards1537043forwards
foulard11257283foulard_
glads75620613_gla_ds
glands85314403_glands
glares75518873_glares
goads77022853go_a_ds
goldarns1043593goldarns
golds75421313gol__ds
goliard936073goliard_
gonads84511733gona_ds
gourds8108253go_urds
guards84611573_guards
haars85620473h_aar_s
haggards14366763haggards
halalas104214083halalas
halals95018313hala_ls
halberds1435183halberds
halers94926923haler_s
halids104016133hal_ids
halliards13104933halliards
haloids113012553haloids
halyard1476973halyard_
hands95327383h__ands
hard85443503h__ard_
hardy125622063h__ardy
hares86255543h__ares
harks126333433h__arks
harls85634503h__arls
harms106829023h__arms
harps105926873h__arps
harts88441593h__arts
haulyards1682833haulyards
haywards1845873haywards
hazard1938403hazard_
heads95127113h_ea_ds
heard95222753h_eard_
hears86737373h_ear_s
hearts96218943h_earts
hegaris11310433hegaris
heralds1137713heralds
herds96424683h__erds
hexads17468203hexa_ds
hilar85418143hilar__
hoar76729163ho_ar__
hoarded12368343ho_arded
hoarder11329233ho_arder
hoarders12307433ho_arders
hoarse94411323ho_arse
hoary114516763ho_ar_y
hoaxes163611693ho_axes
hodad10311353hoda_d_
hodaddy1642133hodaddy
hods87239873ho___ds
hoers85724923ho_er_s
hogans105914313hoga_ns
hold86235063hol__d_
holdalls1244333holdalls
holders113715903holders
holdups1333593holdups
holed95634133hol_ed_
holes84748653hol__es
holies94630033hol_ies
holisms123811113holisms
holists104413963holists
holked144913663holked_
holks124720563hol__ks
hollaed11359853hollaed_
holland11349473holland_
hollas94616903hol_las
hollers103818233hollers
hollies103420813hollies
holloas103814943holloas
holloes103818193holloes
holloos104013583holloos
hollos95320633hol_los
hollows134412333hollows
holms105117803hol__ms
hols76946293hol___s
holts85627913hol__ts
homages131011593homages
hombres14369883hombres
homelands1545453homelands
homers114821983homer_s
homewards1844523homewards
honans94814503hona_ns
honers94324973honer_s
honors94816793honor_s
hoods95124083ho__ods
hoorahs13399613hoorahs
hoorays13418383hoorays
hopers114222973hoper_s
horahs126313873hora_hs
horary12310383horar_y
horas86333103ho__ras
horde94623053ho__rde
hordes104921633ho__rdes
horns86125333ho__rns
hosers95223973hoser_s
hotbeds13315003hotbeds
hotrods1148283hotrods
hounds104413133ho_unds
houris94514583ho_uris
hours85422393ho_ur_s
hovers124320253hover_s
howlers133312353howler_s
hoyas115016163hoya__s
hulas84920883hula__s
hurds95219073h__urds
hylas114815903hyla__s
inlands838783inlands
innards837153innards
inwards1138343inwards
islands837323islands
izzards16143963izzards
jeopards1843683jeopards
jowars16369653jowar_s
kolas94822233kola__s
lads56549143__la_ds
lairds74711613__lairds
lands65426903__lands
lard56742003__lard_
lardy96119273__lardy
lares54852633__lares
laris54737463__laris
larks95227813__larks
lars46956573__lar_s
lauds65618483__lauds
leopards1144753leopards
leotards945303leotards
liards75212613_liards
lizards17427613lizards
loads65323373lo_a_ds
lords64923503__lords
lowlands1244373lowlands
malars85020683malar_s
mallards1138323mallards
mazards1937703mazards
milords10117853milords
molar75223093molar__
molas75132093mola__s
molds85324833mol__ds
monads94515303mona_ds
monarda1046613monarda
monardas1145713monardas
mylars114310443mylar_s
nards65928463__nards
nomads94711603noma_ds
nonarts7311303nonarts
norlands936443norlands
oars46846033_o_ar_s
olds55926583_ol__ds
onwards1137173onwards
pards85634333__pards
petards104311153petards
plaids94312443_plaids
pochards1646853pochards
polar75623453polar__
polarise10513903polarise
polaron939843polaron
polarons1039863polarons
polers84225643poler_s
pollard103511143pollard_
poniards1145823poniards
poplars113910333poplar_s
poulard10299733poulard_
poularde11276573poularde
poulardes12286183poulardes
regards94112563regards
relands85214883relands
retards85015003retards
rewards114813993rewards
ritards8439943ritards
roads66523623ro_a_ds
roars55622243ro_ar_s
robands10219863robands
salads75316963sala_ds
sards64736183__sards
scholars1336683scholar_s
shards104319173_shards
shofars1335833shofar_s
soars54732513so_ar_s
sofars94712783sofar_s
solaces93116133solaces
soland75115043soland_
solanos74412853solanos
solans64122493sola_ns
solar55927343solar__
solaria7312493solaria
solarise8512543solarise
solarism10810383solarism
solates73523853solates
solids74116403sol_ids
sonars64818973sonar_s
sords64527803so__rds
souaris7312333souaris
sowars94318013sowar_s
swards105415133_swards
tabards10310383tabards
talars66021683talar_s
toads65621073to_a_ds
tolanes74216313tolanes
tolans64319273tola_ns
tolar55524113tolar__
tolas54532773tola__s
toluids835323toluids
toward10311063toward_
trolands936423trolands
uphoards1443763upho_ards
uplands1036943uplands
upwards13135963upwards
vawards14457573vawards
velars93913723velar_s
visards11328153visards
vizards20377263vizards
volar86917413volar__
wards97734403__wards
wizards20326403wizards
woads94818443wo_a_ds
woalds10427583wo_alds
wolds95420183wol__ds
words95425073wo__rds
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 Filter1786911340270.406440125.6
2DLD Change Limit1340273056.97019229.1
3Display Results3053050.1102772.7
 (SQL Overall)1786913057.48623870.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.